Hi,
This is probably quite simple, but it's giving me a headache.
I have 2 colums, 1 for a date (A) and one for an amount in GBP (B) (i'm a bookkeeper),its for simple anaysis of recipts (petrol mainly)
What i want is a flag in colum C that will shout if a recipt is duplicated.
IE both date and amount are the same as another.
So if A1 = 12/12/08 and B1 = £10.99
and A97 = 12/12/08 and A97 = £10.99 then C97 ="DUPLICATION"
I dont need to know where it is duplicated (but would be better)
(I'm using Excel 2002)
Any help would be great
Thanks in advance
Tony.
Bookmarks