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.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!