Duplicate formula

M

Mark Allen

I am using this formula to de-duplicate a spread sheet

=IF(COUNTIF($A$2:A2,A2)=1,"First Occurrence","Duplicate")

However, if one cell has a "9" in it and another has "99" in it, it thinks
it is a duplicate.

Is there a way to make it check for a complete match ???

Hope some can help !!

Regards

Mark
 
T

TomPl

I have tested your formula and do not get false matches as you have described.

Tom
 
Top