Excel Dynamic Array Formulas

Excel Tips and Tricks

In January 2020 Microsoft released Dynamic Array Formulas for Excel. I’ll show you the six new functions available to Office 365 Excel users. These functions are a dramatic change for Excel spreadsheets and that is why it took 2 years for Microsoft to release them. The data results from these functions will “spill” over into multiple rows and columns. This solves many problems with older functions that could not handle multiple results. You now have six powerful new functions to enhance your use of Excel.