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]

			D											O
1	5/26/2015	Imperial	011-461-018	1	$320			3		$0				duplicate
1	5/26/2015	Imperial	011-461-018	1	$320			3		$0				duplicate

<colgroup><col><col><col><col><col span="11"></colgroup><tbody>
</tbody>

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?