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
  • 8 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:

Markiplier

“Hello new world, how’s it going? I’m here to wreck everything.” Mark Edward Fischbach (born June 28, 1989), known by his online alias, Markiplier, is an American internet personality, and content...

read more

  • Comments
  • Related videos