BYROW

BYROW(array, lambda(row))

Returns the results from applying a LAMBDA function to each row in an array.

arrayAn array to be separated by row.
lambdaA nested LAMBDA function that takes a single parameter.
rowA row from 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 a single parameter.
* This LAMBDA function must have parameter names that do not contain any numbers.
* This LAMBDA function must have a calculation formula that is compatible with arrays.
* You can use the BYCOL function to return the results from applying a LAMBDA function to each column in 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

 ABCD
1=BYROW(5,LAMBDA(p_one,SUM(p_one,p_one))) = 10100200300
2=BYROW(10,LAMBDA(p_one,SUM(p_one,p_one))) = 20   
3=BYROW({10,20},LAMBDA(p_one,SUM(p_one))) = 30   
4=BYROW({10,20,30,40},LAMBDA(p_one,MAX(p_one))) = 40   
5=BYROW(B1:D1,LAMBDA(p_one,SUM(p_one))) = 600   
6=BYROW(B1:D1,LAMBDA(p_one,AVERAGE(p_one))) = 200   
7=BYROW({10;20},LAMBDA(p_one,SUM(p_one))) = {10; 20}   
8=BYROW(B1:D1,LAMBDA(p_one,2*p_one)) = #CALC!   

1 - What is the result of passing in the value "5" to the function "SUM(5,5)".
2 - What is the result of passing in the value "10" to the function "SUM(10,10)".
3 - What is the result of passing in the array values {10,20} (with commas) to the function "SUM(array)".
4 - What is the result of passing in the array values {10,20,30,40} (with commas) to the function "MAX(array)".
5 - What is the result of passing in the values from cell reference "B1:B3" to the functon "SUM(array)".
6 - What is the result of passing in the values from cell reference "B1:B3" to the functon "AVERAGE(array)".
7 - What is the result of passing in the array values {10;20} (with semi-colons) to the function "SUM(array)".
8 - If the argument passed to the LAMBDA function is not an array, then #CALC! is returned.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top