In fall 2018, Microsoft announced a new feature in Excel called “dynamic array formulas”. In a nutshell, this feature allows formulas to return multiple results to a range of cells on the worksheet based on a single formula entered in one cell. This behavior is called “spilling” and results appear in a “spill range”. All results are dynamic – if source content changes, the results dynamically update to stay in sync. To leverage this feature, Microsoft also released new dynamic array functions: These functions make many long-standing and difficult problems in Excel much easier. For details and examples, see: Dynamic Array Formulas in Excel Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.