Channel: ExcelIsFun

Category: Education

Tags: conditional formattingformulas and functionsarray functionhighline collegeexcel magic trick 1787mike girvinemttake functionemt 1787excel is funexcel magicdrop functiondynamic spilled formula reportsexcel functionsexcel fundynamic spiled array formulasexcel statistics% frequencyexcel array formulasexcelvstack array functionmicrosoft 365 excelexcel 365excel formulasexcelisfunfrequency distribution with total row

Description: Download Excel File: 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