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
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
I had the same problem and if you do a vlookup formula, it will be able to show you which ones are duplicated
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks