Chip Pearson has lots of ways to work with duplicates/uniques at:
http://www.cpearson.com/excel/duplicat.htm
Dirk_Bob wrote:
I have two sheets in a workbook. The first column in each sheet has part
numbers.
I would like to compare worksheet1 column a to worksheet 2 column a and
identify duplicate values. I have not been able to make this work.
--
Dirk
--
Dave Peterson