Download Excel File: https://ift.tt/2O0QoBY
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: https://ift.tt/1kSFWvs
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)