Lambda Functions

BYCOL	(Microsoft 365) The results from applying a LAMBDA function to each column in an array.
BYROW	(Microsoft 365) The results from applying a LAMBDA function to each row in an array.
ISOMITTED	(Microsoft 365) The boolean True or False depending whether the value in a LAMBDA is missing.
LAMBDA	(Microsoft 365) The results of a formula added as a named range.
MAKEARRAY	(Microsoft 365) The array calculated by applying a LAMBDA function.
MAP	(Microsoft 365) The array formed by applying a map using a LAMBDA function.
REDUCE	(Microsoft 365) The total value after reducing an array by applying a LAMBDA function.
SCAN	(Microsoft 365) The array after applying a LAMBDA function to each value and returns an array.

BYCOL (Microsoft 365) The results from applying a LAMBDA function to each column in an array.
BYROW (Microsoft 365) The results from applying a LAMBDA function to each row in an array.
ISOMITTED (Microsoft 365) The boolean True or False depending whether the value in a LAMBDA is missing.
LAMBDA (Microsoft 365) The results of a formula added as a named range.
MAKEARRAY (Microsoft 365) The array calculated by applying a LAMBDA function.
MAP (Microsoft 365) The array formed by applying a map using a LAMBDA function.
REDUCE (Microsoft 365) The total value after reducing an array by applying a LAMBDA function.
SCAN (Microsoft 365) The array after applying a LAMBDA function to each value and returns an array.