Comparing 2 sets of data

  • Thread starter Thread starter Dave Aanderson
  • Start date Start date
D

Dave Aanderson

A spreadsheet, Column A is a inventory list of part
numbers in the format "300112s" items, column H is a list
of all the spares associated with a particular area.
There are about 12000 inventory items, 600 area items.
Do you know of a method/formula that will allow column H
to be compared to column A and any matches indentified and
extracted to say another column or worksheet?
Thanks
 
Assuming there are headers in row 1, in I2, put this formula

=IF(COUNTIF($A$2:$A$12000,$H2)>1,"X","")

and copy down through I600.

This will put an X in column I when H matches an entry in column A. Then you can AutoFilter this
list, displaying the rows with an X, then copy to your other worksheet.
 
Back
Top