SCAN |
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. |
array | An array to be scanned. |
lambda | A nested LAMBDA function that takes two parameters. |
accumulator | The value totalled up and returned as the final result. |
value | The calculation applied to each element in the array. |
REMARKS |
* This function was 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 first released in July 2021. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
1 - We would like to return an array that contains the concatenation of all the strings. 2 - We would like to return an array that contains the concatenation of all the strings. 3 - We would like to return an array that contains the multiples of all the numbers. 4 - We would like to return an array that contains the multiples of all the numbers. 5 - We would like to return an array that contains the total of all the numbers with an initial value of 20. 6 - We would like to return an array that contains the total of all the numbers with an initial value of 20. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top