Feb 07 2018
05:23 PM
- last edited on
Jul 12 2019
11:02 AM
by
TechCommunityAP
Feb 07 2018
05:23 PM
- last edited on
Jul 12 2019
11:02 AM
by
TechCommunityAP
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?
Feb 08 2018 12:20 AM
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.