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


1 Reply


An option with Power Query. Sample attached