Need formula to Check Duplicates

[Daniel]

Hi everyone,

I need a formula that will put the word duplicate in a
column based on some codes in another column, leaving the
first code blank, then all subsequent times it comes
across the same code, it will put the word "duplicate".

I generally use the following formula, but this puts the
word duplicate next to the first ones it comes across
then leaves the last one blank. I need to keep the data
in the current order so I can't sort the data.

=IF(COUNTIF(a2:$a$130,a2)>1,"Duplicate","")

Thanks

Dan

 

[Bob Umlas, Excel MVP]

=IF(COUNTIF($a$2:$a$130,a2)>1,"Duplicate",""

 

[JE McGimpsey]

Check out

http://cpearson.com/excel/duplicat.htm