# BYCOL

BYCOL(array, lambda(column))

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

 array An array to be separated by column. lambda A nested LAMBDA function that takes a single parameter. column A column 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 BYROW function to return the results from applying a LAMBDA function to each row 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

 A B 1 =BYCOL(5,LAMBDA(p_one,SUM(p_one,p_one))) = 10 100 2 =BYCOL(10,LAMBDA(p_one,SUM(p_one,p_one))) = 20 200 3 =BYCOL({10;20},LAMBDA(p_one,SUM(p_one))) = 30 300 4 =BYCOL({10;20;30;40},LAMBDA(p_one,MAX(p_one))) = 40 5 =BYCOL(B1:B3,LAMBDA(p_one,SUM(p_one))) = 600 6 =BYCOL(B1:B3,LAMBDA(p_one,AVERAGE(p_one))) = 200 7 =BYCOL({10,20},LAMBDA(p_one,SUM(p_one))) = {10, 20} 8 =BYCOL(B1:B3,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 semi-colons) to the function "SUM(array)".4 - What is the result of passing in the array values {10;20;30;40} (with semi-colons) 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 commas) to the function "SUM(array)".8 - If the calculation formula passed to the LAMBDA function is not compatible with arrays, then #CALC! is returned.

© 2022 Better Solutions Limited