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 value True or False depending whether the value in a LAMBDA is missing.
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 appliying 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 value True or False depending whether the value in a LAMBDA is missing.
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 appliying a LAMBDA function to each value and returns an array.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top