Mark Duplicates Mark Duplicates ptrifile (TechnicalUser) (OP) 29 Nov 16 14:34 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 RE: Mark Duplicates SkipVought (Programmer) 29 Nov 16 14:44 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!