Download Excel File: https://ift.tt/2QdaUkX
In this video learn how to take multiple columns filed with formulas and list all the formulas and the cell reference that the formula sits in in a Vertical Column with a single cell formula. See the Functions: ADDRESS, ROW, COLUMN, FOMULATEXT, IFNA and TRANSPOSE.
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)