New Dynamic Array Functions & Spilled Array Formulas
What are Dynamic Array Formulas? Excel formulas that return multiple values (an array), will now display their results in adjacent cells. Microsoft has called this behaviour spilling, with the formulas being called spilled array formulas. Excel will automatically create an output range in which to spill results. The size of the output range will dynamically… Read More »New Dynamic Array Functions & Spilled Array Formulas