Forum Discussion

BillBrosnick's avatar
BillBrosnick
Copper Contributor
Sep 07, 2022

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 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?

  • BillBrosnick 

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

     

Share