Lambda Functions

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

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