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

Returns the array after appliying 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 LAMBDA that is called to scan the array.
accumulatorThe value totalled up and returned as the final result.
valueThe calculation applied to each element in the array.


* Added in Microsoft 365 and is only available to Office Insiders at the moment.
* This function can return a Dynamic Array Formula.
* This function uses the LAMBDA function.
* This function was released in July 2021.
* For the Microsoft documentation refer to


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