Excel: Find values in one column that are not in another
- Joel Lipman
- Excel
- Hits: 19087
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new...
Why?
Consider the 3 following columns in an Excel spreadsheet:
Old New Exists in Old? --------- --------- -------------- 123456 234567 234567 345678 345678 456789 567890 597890
- Old New Exists in Old?
- --------- --------- --------------
- 123456 234567
- 234567 345678
- 345678 456789
- 567890 597890
How?