Vloggest Entertainment

Watch all your favorite videostars!
  • Share this video
  • facebook
  • Google+
  • Twitter
  • submit to reddit Reddit
  • Tags
  • Show tags

Excel Magic Trick 1441 Power Query to Extract Items ...

ExcelIsFun Follow
  • Video description
  • 11 months ago
  • 1,089 views
  • 58 likes
  • 21 comments
In this video see how to use an Left Anti Join in Power Query to Extract Items in List 1 that are NOT in List 2.
Download File:
Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1441-1442Start.xlsx
Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1441-1442Finished.xlsx
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm

Related Videos for Comparing Two Lists and Extracting Records:
Other Excel Methods for Comparing Two Lists:
Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples)
Excel Magic Trick 1229 Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color
Excel Magic Trick 1441: Power Query to Extract Items In List 1 That Are NOT In List 2
Excel Magic Trick 1442: DAX Query & EXCEPT Function to Extract Items In List 1 That Are NOT In List 2
Vlogger of the day:

Dude Perfect

Dude Perfect is an American entertainment show focusing on extreme sport tricks aired on YouTube. The group has 4 members: twins Coby and Cory Cotton, Garrett Hilbert, Cody Jones, and Tyler Toney;...

read more

  • Comments
  • Related videos