Here's an odd one for you - I am trying to reconcline between a visa statement and a sales list for the $ of a sale.

I have 2 columns, 1 from the POS and the other from Visa with the sale amount. I tried using conditional formatting but if course that does not count unique values.

So if, for example:

list 1
200
200
250
50
125

List 2
200
250
50
125
100

I'd like on list 1 one of the 200's flagged (since it's only in list 2 once) and on list 2 the 100 flagged since it does not appear on list 1.

Suggestions?