You can use the method from here to tag the parts

http://www.cpearson.com/excel/Duplicates.aspx

--


Regards,


Peo Sjoblom

"debvan" wrote in message
...
I have two spreadsheets that I need to compare. The common data is product
numbers. One spreadsheet will remain static but the other (bill of
materials
- BOM) will be updated weekly. The static spreadsheet indicates parts to
be
scrapped. I need to check the BOM spreadsheet to see if it contains any
of
the scrapped part numbers. The second step is to then indicate those
parts
as scrapped in a new column on the BOM spreadsheet.

I have some intermediate skills in Excel so an easy solution would be
appreciated.