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.
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