# 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 released in July 2021.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A B C D E 1 =SCAN(1,C1:B2,LAMBDA(p_one,p_two,p_one&p_two) = {"a","ab","abc";"abcd"} a b c 2 =SCAN(1,C1:E2,LAMBDA(p_one,p_two,p_one&p_two) = {"a","ab","abc";"abcd","abcde","abcdef"} d e f 3 =SCAN(1,C3:E4,LAMBDA(p_one,p_two,p_one*p_two) = {1,2,6;24,120,720} 1 2 3 4 =SCAN(5,C3:E4,LAMBDA(p_one,p_two,p_one*p_two) = {5,7,11;29,124,724} 4 5 6 5 =SCAN(20,C3:E4,LAMBDA(p_one,p_two,p_one+p_two) = {22,28,38,42,50,62} 2 4 6 6 =SCAN(100,C3:E4,LAMBDA(p_one,p_two,p_one+p_two) = {102,108,108,42,50,62} 8 10 12

 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.

© 2022 Better Solutions Limited