| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Compare spreadsheets and indicate matched data
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I compare 2 spreadsheets of data? | Excel Worksheet Functions | |||
| How do I compare data between spreadsheets? | Excel Worksheet Functions | |||
| Compare data on two spreadsheets. | Excel Discussion (Misc queries) | |||
| compare data from several spreadsheets | Excel Discussion (Misc queries) | |||
| How to compare 2 lists and return un-matched? | Excel Worksheet Functions | |||
Threaded Mode
