Probably down temporary, you can use something like this

=IF(COUNTIF($A$2:A2,A2)1,"Duplicate","")

where your list starts in A2, copy down in an adjacent column and it will
tag from the second instance of a duplicate, if you want from the first
instance


=IF(COUNTIF($A$2:$A$2000,A2)1,"Duplicate","")

--
Regards,

Peo Sjoblom


"Duplicate entries" wrote in
message ...
Thanks Dave but this URL doesn't work. Any other suggestions?

"Dave Peterson" wrote:

Chip Pearson has tons of ways of working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

Duplicate entries wrote:

How do I search for duplicate entries in an excel list?

--

Dave Peterson