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