Jim,

See www.cpearson.com/excel/duplicat.htm for some example code and
formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"JimNC" wrote in message
...
How do I find duplicates in a list that changes weekly. I want
the adjacent
column to indicate an error if the column value is duplicated
else where in
the list.