Dynamic Spilled Arrays: Show All Formulas For All Columns in Cells as Auditing Trail EMT 1524
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1524-1525.xlsx
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: 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)