Hi,
I am trying to use the below formula to identifty the 'Duplicate" cell content of a column from A2:A200
=IF(MAX(COUNTIF(A2:A200,A2:A200))>1,"Duplicates","No Duplicates")
If I have a 4 repeated value....then the first three is identified as "Duplicate" & the fourth one is identifed as "No Duplicate".
Now, I need the other way....
The first Value should show as "No Duplicate" & the rest three values should show as "Duplicates"
Can any one help me ?
Kind Regards
Shadmani
Bookmarks