Learn Excel Episode 290: Comparing Lists

Posted in Companies, Podcasts on July 02, 2008


Learn Excel Episode 290: Comparing Lists

I use this trick all of the time. Say that you have two versions of a list. You have the current version and an old version. You want to see what changed between the two versions. Rather than try to build complicated VLOOKUP formulas, use a simple pivot table to compare the two lists. Episode 290 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, pivot