Adding an IF statement to find duplicates in column and identify duplicates in another cell

[JPBREWER25]

I am trying to find an easy way to distinguish duplicate values in a column. Then in another column/cell place the word "DUPLICATE". I cant seem to get the IF formula right. Who can help?

So lets say I am trying to find duplicates in a range D1:D2000 then in another Cell place the word "DUPLICATE" IF there is a duplicate in that range?

I used a Conditional Format to find them and Format the cells to distinguish duplicates already, but the BOSS wants the word "DUPLICATE" in another cell in the row of the duplicates.

 

[phoenixdown]

=IF(COUNTIFS(A:A,A2) > 1,"Duplicate","")

Where A:A can be the range A1:A1000 you are looking up.

 

[JPBREWER25]

I apologize but I am a NOOB when it comes to IF statements. I get the range part but the formula, but where do I put the cell I want "duplicate" to show up in, A2?
In my case here: =IF(COUNTIFS(D:D,O4) > 1,"Duplicate","") but that does not seem to work? Your formula works of course as I tested it. Thanks for your help!!!

 

[MARZIOTULLIO]

Hi

E1 =IF(COUNTIF($D$1:$D$2000,D1)>1,"Duplicate","") copy down

 

[JPBREWER25]

[TABLE="width: 1089"]
<colgroup><col><col><col><col><col span="11"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]5/26/2015[/TD]
[TD]Imperial[/TD]
[TD]011-461-018[/TD]
[TD]1[/TD]
[TD]$320[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]$0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]duplicate[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]5/26/2015[/TD]
[TD]Imperial[/TD]
[TD]011-461-018[/TD]
[TD]1[/TD]
[TD]$320[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]$0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]duplicate[/TD]
[/TR]
</tbody>[/TABLE]

I would like it to look like this but that last formula =IF(COUNTIF($D$1:$D$2000,D1)>1,"Duplicate","") is not working like I want it to?