excelisfun | Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 @excelisfun | Uploaded 1 year ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/EMT1811.xlsx
Learn how to extract customer names who did not buy products from a specified list with worksheet formulas and Power Query.
Topics:
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