Excel Tips and TricksIn 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