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