# 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

 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.