compare 2 lists

Even Faster Way to Compare 2 Lists in Excel [Quick Tip]

The quickest way to find all about two lists is to select them both and them click on Conditional Formatting -> Highlight cells rules -> Duplicate Values (Excel 2007). The result is that it highlights in both lists the values that ARE the same. Then in one list non-highlighted are values that are not present in the second list, and opposite for the second list. I think it is sell “geeky”, but it gets job done very very quickly when you don’t want to mess around.

A Ridiculously easy and fun way to compare 2 lists

[works only Excel 2007+, use theabove technique if you are on excel 2003 or earlier]

1. Select cells in both lists (select first list, then hold CTRL key and then select the second)
2. Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values
3. Press ok.
4. There is nothing do here. Go out and play!

See the screencast aside to see how this works