Lambda functions

## Lambda functions The **LAMBDA function** gives you the ability to define a custom function using Excel's own formula language. And the following new functions can take lambda function as parameter, making lambdas more powerful. - **BYROW**: Applies a LAMBDA to each row and returns an array of the results. - **BYCOL**: Applies a LAMBDA to each column and returns an array of the results. - **SCAN**: Scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value. - **REDUCE**: Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator. - **MAP**: Returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value. - **MAKEARRAY**: Returns a calculated array of a specified row and column size, by applying a LAMBDA. - **ISOMITTED**: Checks whether the value in a LAMBDA is missing and returns TRUE or FALSE.