Forum Discussion
Comparisons
I am dealing with 2 lists of customer numbers. I want to compare one list to the other and see if there are any differences. For instance, list #1 has customers 1234, 2345, 1222, 2222. List #2 has cu...
An alternative could be conditional formatting. Select a range that contains List1 and List2 and then follow Conditional Formatting-> Highlight cells rules -> Duplicate values and then select Unique Values ("Eindeutige" in the attached sheet in german Excel).