Lambda functions
Microsoft created the Lambda function in Excel as a way for people to create user-defined functions without doing any programming, just by using the same Excel formulas they do within cells. In December 2020, when the Lambda function was released for Excel 365 and Excel on the web, many people saw it as a weak attempt to replicate the Visual Basic for Applications (VBA) user-defined functions and pointed out some limitations it has. Limitations such as it needs to be put in a named range to be able to call it like a proper function. But Microsoft was just getting started then and the Lambda function is just one of many functions it released to empower users to create truly powerful custom functions.
This section is all about Lambda and the functions that are built on it. Or, should I say, that require it. Altogether, I call them Lambda functions. We will be covering them individually, and they are as follows:
LAMBDABYCOLBYROWMAKEARRAY
...
