Extract Customer Names, Not in Master Lists with Power Query – Excel Magic Trick 1599

Download Excel File: https://ift.tt/2ZxRsIb
Learn how to Compare Two Lists and extract customer names that are in List 2 that are not in List 1using Power Query. See how to use the Merge feature, and the join operation; Left-Anti Join. Also see how to extract items in both lists using a Inner Join.
Related Video:
MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples

View on YouTube