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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]Duplicate[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]Duplicate[/TD]
[/TR]
</tbody>[/TABLE]

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","")