Lambda Functions

link - techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-helper-functions-lambdas-as-arguments-and-more/ba-p/2576648
link - support.microsoft.com/en-gb/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67

LAMBDA	The results of a formula added as a named range.
BYCOL	The results from applying a LAMBDA function to each column in an array.
BYROW	The results from applying a LAMBDA function to each row in an array.
GROUPBY	The summary table after grouping and aggregating by row.
ISOMITTED	The value True or False depending whether the value in a LAMBDA is missing.
MAKEARRAY	The array calculated by applying a LAMBDA function.
MAP	The array formed by applying a map using a LAMBDA function.
PIVOTBY	The summary table after grouping and aggregating by row and column.
REDUCE	The total value after reducing an array by applying a LAMBDA function.
SCAN	The array after appliying a LAMBDA function to each value and returns an array.

LAMBDA The results of a formula added as a named range.
BYCOL The results from applying a LAMBDA function to each column in an array.
BYROW The results from applying a LAMBDA function to each row in an array.
GROUPBY The summary table after grouping and aggregating by row.
ISOMITTED The value True or False depending whether the value in a LAMBDA is missing.
MAKEARRAY The array calculated by applying a LAMBDA function.
MAP The array formed by applying a map using a LAMBDA function.
PIVOTBY The summary table after grouping and aggregating by row and column.
REDUCE The total value after reducing an array by applying a LAMBDA function.
SCAN The array after appliying a LAMBDA function to each value and returns an array.