Forum Discussion

Phillip Fleischmann's avatar
Phillip Fleischmann
Copper Contributor
Feb 07, 2018

FILTER LIST 2 for Items on List 1

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 ...
BI & Data Analytics
Show and Tell
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 08, 2018

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.