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 convert frequency distribution into original column of data using the functions: SEQUENCE, IF and TOCOL. Lean about array operations of arrays with different dimensions. Topics: 1. (00:00) Introduction 2. (00:28) Formula to convert frequency distribution into original column of data. See the functions SEQUENCE, MAX, IF, and TOCOL. 3. (02:56) Old Scholl way with Power Query 4. (03:13) Summary, Closing, Video Links