# 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 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 1 =BYCOL(5, LAMBDA(p_one, SUM(p_one, p_one))) = 10 2 2 =BYCOL(10, LAMBDA(p_one, SUM(p_one, p_one))) = 20 4 3 =BYCOL({10;20}, LAMBDA(p_one, SUM(p_one))) = 30 6 4 =BYCOL({10;20;30;40}, LAMBDA(p_one, MAX(p_one))) = 40 5 =BYCOL(B1:B3, LAMBDA(p_one, SUM(p_one))) = 12 6 =BYCOL(B1:B3, LAMBDA(p_one, AVERAGE(p_one))) = 4 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.