Download Excel File: https://excelisfun.net/files/EMT1788-1789.xlsx
Learn how to create a formula Frequency Distribution Report with Total Row and learn how the DROP and TAKE Array Functions can be helpful in dynamic spilled array formula reports..
Topics:
1. (00:00) Introduction
2. (00:20) Why we are NOT going to use a PivotTable for this type of example
3. (00:48) Microsoft 365
4. (01:14) Formula for first column of frequency distribution. See SORT, UNIQUE and VSTACK functions
5. (02:34) Formula for second column of frequency distribution. See VSTACK, DROP, COUNTIFS and ROWS functions
6. (04:30) Conditional Formatting for Dynamic Spilled Array Report. Use Logical Formulas with Relative and Mixed Cell References
7. (06:54) Add New Data to Test Dynamic Report
8. (07:04) Bonus #1: Formula for % of Total with the TAKE or ROWS functions.
9. (09:26) Bonus #2: Look at formulas that will work without the Beta Functions.
10. (11:19) Summary
11. (11:35) Closing, Video Links and preview of next video