Financial Modellers and Data Analysers should take note of Microsoft Excel’s new Dynamic Array functions
Notice Accountants should be aware of Excel’s new Dynamic Array functions that enable you to work with multiple values at the same time in a formula. Dynamic Arrays and the new functions are only available Excel 365 and Excel 2021 Information and Implications The Dynamic Array functions will improve the ability to sort and find …