Duplicate formula
 

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

Duplicate formula
 

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

Tom

Duplicate formula
 

Thanks Tom, investigated further and I had a load of hidden rows!!!!

"TomPl" wrote:

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

Tom