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