Lists, lists, lists … It sometime seems that I am swimming in a sea of lists. Lists of customers, updated lists of customers, sales by week, sales for the current week, book lists, revised lists of books, etc. Lists seem to beget more lists and both beget problems – How to compare pairs of lists to avoid duplicates and redundancies!
If you can relate to this scenario, I know that you will enjoy this Excel Video Lesson.
Three Techniques Used in My Tutorial
1) Use the =MATCH() Function
2) Use the =VLOOKUP() Function
3) Use a Pivot Table in Excel 2007
Shop at My Secure Online Shopping Site
If you enjoyed this Excel Video Lesson, I am confident that you will enjoy the lessons on my DVD-ROM, “The 50 Best Tips for Excel 2007.” Click on this link to visit my secure online shopping website.
You can watch this Excel Video Lesson on YouTube – Subscribe to my YouTube Channel – DannyRocksExcels
Watch My Video Now
Related Excel Video Lessons:
- View Excel Worksheets Side by Side
- Visit my Index of Excel Video Lessons
- Use Conditional Formatting to Compare Two Excel Lists
[…] an earlier Excel Video Lesson, I demonstrated how to compare two Excel lists using either the MATCH() Function or the VLOOKUP() Function. Conditional Formatting […]