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.|
|array||An array to be scanned.|
|lambda||A LAMBDA that is called to scan the array.|
|accumulator||The value totalled up and returned as the final result.|
|value||The 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 support.microsoft.com
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top