Comparing values
 

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

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

I had the same problem and if you do a vlookup formula, it will be able
to show you which ones are duplicated


--
Coltsfan
------------------------------------------------------------------------
Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982
View this thread: http://www.excelforum.com/showthread...hreadid=398722