Forum Discussion

Phillip Fleischmann's avatar
Phillip Fleischmann
Copper Contributor
Feb 08, 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 List 2 for the screws in List 1?

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

BI & Data Analytics
Show and Tell
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    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. 

Resources