Occasional Visitor

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 customers 1234, 2345, 1222, 123, and 2222. I want to compare the two lists and return the value 123 as the customer that does not appear on both lists. How might I do this?

1 Reply


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).

unique values.JPG