Excel Dynamic Arrays: Cross Tabulated Report, Totals Top & Left MMULT Array Function (EMT 1526)
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1526-1527.xlsx
This video is a follow up to EMT 1520. In this video we see how to create fully Dynamic Cross Tabulated Report driven by formula inputs, and have totals at the Left and Above using the MMULT Array Function.
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)
Original video about Cross Tab Report, EMT 1520: https://www.youtube.com/watch?v=ZXn0D4Ch7zg
Cross Tab Report with totals at bottom and Right, EMT 1528: https://www.youtube.com/watch?v=wHeXjYQGvX8
MMULT Array Function Video: https://www.youtube.com/watch?v=RyorWHIKPC0