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
=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