
New Text and Array Functions
Microsoft announce new Text and Array functions for Excel
News & insights for the everyday modeller
Microsoft announce new Text and Array functions for Excel
The release of LAMBDA has been celebrated as a seminal moment for Microsoft Excel – paralleled only by the Pivot Table back in 1994. And this comes hot on the heels of Data Types and Dynamic Array functionality. It’s an exciting time for us Excel geeks.
In this series of articles, we will look at the future of Excel.
Discover the key Excel functions for financial modelling.
Sum rows that meet specifc criteria
Looks up values from another table
Returns a value from a range based on the position specified
Quickly understand how a workbook is structured.
Returns the smallest value from a range of numbers