FILTER LIST 2 for Items on List 1

Occasional Visitor

Have a hardware store

Have a spreadsheet of all screws called List 1

We have a Clearance Sale

Have a spreadsheet of ALL items NOT sold called List 2

How do I filter remaining unsold items in List 2 for the screws in List 1?

I need a final list of what screws have NOT been sold?

1 Reply

Hi Philip,

 

If use Power Query (Get & Transform):

I hope you have some unique field which identifies your hardware, let say ID. When load both list 1 and list 2 as connections only and with separate query merge them with Inner join (matching records only), load resulting table into the Excel sheet, it will show not sold screws.