Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query

Learn how to extract customer names who did not buy products from a specified list with worksheet formulas and Power Query.

In this Video

1. (00:00) Introduction
2. (00:41) Worksheet Formulas and Functions: FILTER, XMATCH, ISNA, AND, and COUNT.
3. (03:27) Formula Bonus #1: LAMBDA
4. (03:56) Formula Bonus #2: Use COUNT function to extract names when they bought no products, one or more products or all products
5. (04:35) Power Query using Group By feature and List.ContainsAny M Code function
6. () Summary, Closing, Video Links

Download Excel File:

https://excelisfun.net/files/EMT1811.xlsx