Comparing Excel spreadsheets within a workbook

Occasional Visitor

I have 2 spreadsheets in a work book.  I need to compare the part numbers and remove the part numbers that are not in both list. Any suggestions on the quickest easiest way?

 

Thank you

Robin12

1 Reply

@Robin121695 

An option with Power Query. Sample attached