Download Excel File: 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
- Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 ( Download)
- 3 ways to compare and clean lists in Excel: VLOOKUP, MATCH, Get & Transform Left Anti-Join ( Download)
- 3 Ways to SIMPLY Compare Matching Values Across Two Files Using Power Query | #powerbi ( Download)
- Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810 ( Download)
- [L0003] How to compare two data sets in Excel – Join Kind Types in Power Query | Excel Snap Reports ( Download)
- Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737. ( Download)
- Excel Magic Trick #147: Dynamic List from Table #2 ( Download)
- Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825 ( Download)
- Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807 ( Download)
- GroupKind.Local in Power Query | Solution to Count Stints Challenge by @GoodlyChandeep using Power Query ( Download)
- Power BI Tutorial Series for Beginners 159: Power Query- List.RemoveMatchingItems ( Download)
- 7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15 ( Download)
- Power BI Tutorial Series for Beginners 163: Power Query- List.Skip ( Download)
- Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787 ( Download)
- 18 - Several Ways from Sunday - Ken Puls ( Download)
