Excel Dynamic Array Formulas

Six new functions available to Office 365 Excel users

In January 2020 Microsoft released Dynamic Array Formulas for Excel. This introduced six new functions available to Office 365 Excel users. The data results from these functions will “spill” over into multiple rows and columns.

Credit to Sele Training