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 Excel 2024.
* 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.