All Content
Timespan
Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query
Jan 10, 2023 3:30 AM

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

External YouTube Channel

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

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