Channel: ExcelIsFun

Category: Education

Tags: formulas and functionsexcel magic trick 1780highline collegemike girvinappend columnsjoin verticallyvstack functionemt 1780excel is funexcel magicadd total row to spilled arrayhstack array functioncreate array formula to spill reportshstackexcel functionsexcel funhstack functionexcelsingle cell reportsadd total rowvstack array functionvstackmicrosoft 365 excelexcel 365excel formulasdynamic spilled array formulasexcelisfun

Description: Download Excel File: excelisfun.net/files/EMT1780.xlsm These two functions were released in March 16, 2022 and are in Beta at that time. Learn about the new HSTACK and VSTACK functions to Create Single Cell Reports With Total Row. Topics: 1. (00:00) Introduction 2. (00:10) 14 new Beta functions were released on March 16, 2022. 3. (01:12) Use HSTACK and VSTACK Array Functions to Create Single Cell Reports With Total Row. 4. (04:40) See the formula on different lines using Alt + Enter. 5. (04:53) Use LET function to create more efficient formulas using HSTACK and VSTACK functions to Create Single Cell Reports With Total Row. 6. (05:11) Summary 7. (05:25) Closing and Video Links