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

Smosh

Smosh is an American web-based comedy duo founded by Ian Andrew Hecox (born November 30, 1987) and Anthony Padilla (born Daniel Anthony Padilla (September 16, 1987). Padilla and Hecox formed a duo ...

read more

  • Comments
  • Related videos