Right Anti Join Power Query

If you have to compare two tables in Excel with thousands of rows or even more rows and looking for the easiest method to do it, watch this video. ( There are several methods how you can do it. In this video I described one of them, of course using Power Query. If you are user of Excel 2013 you need to install Power Query separately and add it as a new Tab from Excel COM AddIn. Another thing you have to know if your data exceeds allowable rows in Excel then you can t save you result on Excel worksheet, you