Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1518-1523.xlsx
In this video learn about how Array Formulas create in the New Office 365 with the Excel Calculation engine will respond when we open the file in an Older Version. We also see what happens when we open on older file filled with Array Formula reacts when we open it in the new Version of Excel.
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)