Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1528.xlsx
This video is a follow up to EMT 1520, and thanks to David Milbrandt, we now can have a fully Dynamic Cross Tabulates Report driven by formula inputs, and have totals at the Right and Bottom. This video will blow your mid with what the New Office 365 Spilled Array Formulas can do!!!!! See the functions: SUMIFS, UNIQUE, SEQUENCE, SORT, INDEX, MATCH, TRANSPOSE, COUNTA and IF. Learn how to Append Columns or Rows to an existing Array.
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), https://www.youtube.com/watch?v=7jJMDGZpjSk

For original Excel Magic Trick 1520: https://www.youtube.com/watch?v=ZXn0D4Ch7zg