From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Execute an anti-join

Execute an anti-join - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Execute an anti-join

“

- [Instructor] Here's a chance to really get elbows deep in and learn about Power Query, because in this session, you're being asked to generate your own data that will set you up for an Anti-Join in Power Query with two criteria, and then apply the Anti-Join with two criteria. Once you have a result, what is that telling you about your data? All right, the wheels should be spinning now. What type of data do you need? Now, go ahead, pause the video. (upbeat music) Okay, let's do some anti-joining. Now, watch this because I would not leave you stranded. I'm going to go over here to I, R, right click, Unhide. Here is some data. If you weren't able to come up with some data on your own, here is some. We've got two data sets here. We've got building, unit, and bedrooms. And it says here, these are the units that need to be painted. And then over here we have vacant units, building and apartment. We got to make…

Contents