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.

Credit Sele Training