SCAN ([initial_value], array, lambda(accumulator, value))

Returns the array after applying a LAMBDA function to each value and returns an array.

[initial_value](Optional) Sets the starting value for the accumulator.
arrayAn array to be scanned.
lambdaA nested LAMBDA function that takes two parameters.
accumulatorThe value totalled up and returned as the final result.
valueThe calculation applied to each element in the array.

* Added in Microsoft 365.
* This function can create a Dynamic Array Formula.
* This function uses the LAMBDA function.
* This LAMBDA function must take two parameters.
* This LAMBDA function must have parameter names that do not include numbers.
* You can use the MAP function to return an identical array by applying a LAMBDA function to do some processing.
* You can use the REDUCE function to return a single value after applying a LAMBDA function to an array.
* This function was released in July 2021.
* For the Microsoft documentation refer to


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