Lambda Functions

BYCOL(2024) The results from applying a LAMBDA function to each column in an array.
BYROW(2024) The results from applying a LAMBDA function to each row in an array.
DROP(2024) The array without certain rows or columns.
GROUPBY(365) The summary table after grouping and aggregating by row.
HSTACK(2024) The array after putting multiple arrays next to each other.
ISOMITTED(2024) The boolean True or False depending whether the value in a LAMBDA is missing.
LAMBDA(2024) The results of a formula added as a named range.
MAKEARRAY(2024) The array calculated by applying a LAMBDA function.
MAP(2024) The array formed by mapping each value to a new value using a LAMBDA function.
PIVOTBY(365) The summary table after grouping and aggregating by row and column.
REDUCE(2024) The total value after reducing an array by applying a LAMBDA function.
SCAN(2024) The array after applying a LAMBDA function to each value and returns an array.
VSTACK(2024) The array after putting multiple arrays on top of each other.
BYCOL
(2024) The results from applying a LAMBDA function to each column in an array.
BYROW
(2024) The results from applying a LAMBDA function to each row in an array.
DROP
(2024) The array without certain rows or columns.
GROUPBY
(365) The summary table after grouping and aggregating by row.
HSTACK
(2024) The array after putting multiple arrays next to each other.
ISOMITTED
(2024) The boolean True or False depending whether the value in a LAMBDA is missing.
LAMBDA
(2024) The results of a formula added as a named range.
MAKEARRAY
(2024) The array calculated by applying a LAMBDA function.
MAP
(2024) The array formed by mapping each value to a new value using a LAMBDA function.
PIVOTBY
(365) The summary table after grouping and aggregating by row and column.
REDUCE
(2024) The total value after reducing an array by applying a LAMBDA function.
SCAN
(2024) The array after applying a LAMBDA function to each value and returns an array.
VSTACK
(2024) The array after putting multiple arrays on top of each other.

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