Mark Duplicates

[ptrifile]

I have a spreadsheet that I need to identify duplicates and I am successfully using =IF(COUNTIF(C:C,C2)>1,"Duplicate","") to do so. I need to know if it is possible to do the following:

I would like the "duplicate" to show for all of the duplicates except for the last entry for each duplicate.....I hope this makes sense.

Thanks in advance for any help.

Paul

 

[SkipVought]

Hi,

=IF(COUNTIF(C2:$C$99999,C2)>1,"Duplicate",if(countif(C2:$C$99999,C2)=1,"FIRST".""))

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}