Download Excel File: https://excelisfun.net/files/EMT1673.xlsx
Learn how to create a single cell spilled array sales report based on day and product.
Topics:
1. (00:00) Introduction.
2. (00:19) Three Formula Solution
3. (00:34) Formula only works in Microsoft 365 Excel.
4. (00:55) UNIQUE Function
5. (01:22) SORT Function with array in second argument to sort first, then second column.
6. (01:46) LET Function.
7. (02:14) CHOOSE Function
8. (03:00) Excel Wizard Two Table trick inside CHOOSE.
9. (04:16) SUMIFS Function
10. (04:30) INDEX Function to lookup column.
11. (05:28) Conditional Formatting
12. (06:30) Add new data and watch report update.
13. (06:35) Summary and End Video Links