excelisfun | Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792 @excelisfun | Uploaded 2 years ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/EMT1792.xlsx
Learn how to create a report that lists a unique list of case sensitive items with the frequency for each.
Learn how to create an Expandable Range in a Spilled Array Formula:
1. (00:00) Introduction
2. (00:49) Power Query Solution. Learn that Power Query is case sensitive by default and that the Group By feature makes the task easy.
3. (02:04) Dynamic Spilled Array Formula Solution. See the powerful Array Functions: BYROW, LAMBDA, LET, VSATCK, HSTACK, INDEX and more.
4. (05:45) Expandable Range in a Spilled Array Formula using BYROW, LAMBDA and INDEX functions.
5. (11:04) Test Solution with new data
6. (11:35) Summary, Closing, Video Links