Use Anti-Join in Excel with Power Query | Everyday Office

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:

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