Select Records in One Table that Aren't in Another Table

🔔 SUBSCRIBE to my channel ➜


This video will cover the Anti Join feature in Excel Power Query. The scenario it fits would be where you want to select all records from one table that doesn't exist in another table. So when we are trying to check whether an item does not exist in another table it's going to be an anti join. Another example is when we are trying to find something that hasn't happened. However in this video we'll cover something that doesn't exist rather that something that didn't happen. So check it out!


#exceltutorial
#doughexcel


🏫 Excel Training ➜

📚 Excel Books & Tech Gear ➜

⚙️ Tools I Use: Screencasting ➜

⚙️ Tools I Use: Microsoft Office ➜

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

formulas,free,create,chart,excel chart,advanced,data,101,how-to,doug h,excel dashboard,doughexcel,basic,excel,charts,make,easy,online,top channel,to,doug h excel,learn excel,tips,analyze,excel function,excel youtube channel,msoffice,how,vlookup,simple,excel formula,dough,tutorial,download,microsoft,training,tricks,how to,windows,learn,graphs,xls,powerpoint,