best way to find new part numbers from one spreadsheet to another

%3CLINGO-SUB%20id%3D%22lingo-sub-1356470%22%20slang%3D%22en-US%22%3Ebest%20way%20to%20find%20new%20part%20numbers%20from%20one%20spreadsheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356470%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20several%20excel%20bill%20of%20materials%20that%20I%20need%20to%20compare%20to%20come%20up%20with%20a%20list%20of%20spare%20parts.%26nbsp%3B%20I%20know%20that%20parts%20are%20duplicated%20between%20each%20so%20I%20want%20to%20be%20able%20to%20find%20the%20non-duplicated%20parts%20between%20two%20spreadsheets.%26nbsp%3B%20How%20would%20I%20best%20achieve%20this%3F%26nbsp%3B%20I%20tried%20conditional%20formatting%20to%20highlight%20unique%20parts%20but%20this%20didn't%20work.%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1356470%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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
Highlighted

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

@nonchriste 

 

for better understanding sharing a sample file my friend