Forum Discussion
best way to find new part numbers from one spreadsheet to another
I have several excel bill of materials that I need to compare to come up with a list of spare parts. I know that parts are duplicated between each so I want to be able to find the non-duplicated parts between two spreadsheets. How would I best achieve this? I tried conditional formatting to highlight unique parts but this didn't work. Thanks.
1 Reply
the best way is to use conditional formatting to highlight duplicates it is done by using the data from 1st spread sheet and select conditional formatting go to new rule, select a new formula for cell than type formula: countif(range of 2 worksheet, select first cell of 2 worksheet)>0
than fill the box with the colour you want to see it then click ok
duplicated will be highllighted....
for better understanding sharing a sample file my friend
