Finding Only One Duplicate

[frank265]

Hi everyone,

I'm hoping one of you excel geniuses might be able to help me out..

I have a spreadsheet with data filled from F2 - F650. In that column there are some duplicates. In Column G I want to use a formula to identify only the duplicates and not the initial entry.

So for example I would like it to look like this

Item	Status
Apples
Apples	Duplicate
Apples	Duplicate

<tbody>
</tbody>

Can someone help with a formula to do this?

Thank you so much for reading this.

Frank

 

[njimack]

Enter this into G2 then copy down as far as required...
=IF(COUNTIF(F$2:F2,F2)>1,"Duplicate","")

 

[frank265]

Thank you so much, this is fantastic - it worked perfectly!!

I really appreciate your help njimack - thanks again!

Enter this into G2 then copy down as far as required...
=IF(COUNTIF(F$2:F2,F2)>1,"Duplicate","")