Anti-Join merging uses one table to filter another - in this instance, we only keep the entries that DON'T exist in the other table. In this tutorial, we look at all the clients we HAVE gotten in touch with, and filter the whole list of clients to show only the ones we HAVEN'T talked to.

This functionality works in databases with SQL, and now with Power Query, we can do it in Excel, too!

Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:
- knacktraining.com/blog/
- knacktraining.com/podcast/

Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.

• Use Anti-Join in Excel with Power Query | Everyday Office ( Download)
• How To Filter Data Using Anti Join In Excel With Power Query ( Download)
• Right anti join in Excel 32 ( Download)
• Left Anti Join in PowerQuery - Microsoft Excel ( Download)
• Left anti join in Excel 31 ( Download)
• Performing a full Anti Join in Power Query - Compare Two Tables ( Download)
• Use Power Query as a VLOOKUP Replacement | Everyday Office ( Download)
• Combine 250 Workbooks in Seconds with Power Query | Everyday Office ( Download)
• How can I use the Left Anti join function in PowerQuery ( Download)
• Left Anti Join & Right Anti Join in POWER QUERY / POWER BI ( Download)
• The Missing Donation Receipts: Using a Power Query Anti-Join against Multiple Records and Criteria ( Download)
• Replacing VLOOKUP with Power Query Outer Joins | Everyday Office ( Download)
• Join Types in Power Query ( Download)
• Power Query Left Anti Merge: Extract the excluded item from the Data Table ( Download)
• Update a Pivot Table from an External Database with Power Query | Everyday Office ( Download)