3 ways to compare and clean lists in Excel: VLOOKUP, MATCH, Get & Transform Left Anti-Join
Someone posted an urgent request. Some contacts from a small list had gotten combined with a larger list.
Question: how can I compare the 2 lists and extract the ones that shouldn’t be in the big list?
This video shows 3 ways:
Formulas:
– VLOOKUP
– MATCH and
Get and Transform (Power Query)
– Left Anti-Join
I hope you enjoy. Please subscribe to the channel, and let me know if you have any Excel questions!
My book: Guerrilla Data Analysis 2nd Edition
My blog: http://datascopic.net/blog-2-2