Download Excel File: https://excelisfun.net/files/EMT1671.xlsx
Learn how to create a Dynamic Sales Report using the new Microsoft 365 Spilled Array Formulas.
Topics:
1. (00:00) Introduction.
2. (00:29) Sorted Unique List of All Combinations of Dates and Products.
3. (00:45) UNIQUE Function.
4. (01:26) SORTBY Function.
5. (01:41) Creating Locked Table Formula Nomenclature.
6. (03:18) INDEX Function to create Two Separate Spilled Arrays.
7. (04:55) SUMIFS Function with Spilled Arrays.
8. (05:36) Conditional Formatting.
9. (06:48) End Video Links