That worked great thanks.
"Peo Sjoblom" wrote:
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