Learn how to extract customer names who did not buy products from a specified list with worksheet formulas and Power Query.
In this Video
- (00:00) Introduction
- (00:41) Worksheet Formulas and Functions: FILTER, XMATCH, ISNA, AND, and COUNT.
- (03:27) Formula Bonus #1: LAMBDA
- (03:56) Formula Bonus #2: Use COUNT function to extract names when they bought no products, one or more products or all products
- (04:35) Power Query using Group By feature and List.ContainsAny M Code function
- () Summary, Closing, Video Links
Download Excel File: