BYCOL function
Summary
Applies a LAMBDA to each column and returns an array of the results
Syntax
BYCOL (array, lambda(column))
The BYCOL function syntax has the following arguments and parameters:
• array An array to be separated by column.
• lambda A LAMBDA that takes a column as a single parameter and calculates one result. The LAMBDA takes a single parameter:
• column A column from array.
• array An array to be separated by column.
• lambda A LAMBDA that takes a column as a single parameter and calculates one result. The LAMBDA takes a single parameter:
• column A column from array.
Example
=BYCOL(A1:C2, LAMBDA(array, MAX(array)))
=BYCOL(A1:C2,LAMBDA(array,SUMSQ(array)))
=BYCOL(A1:C2,LAMBDA(array,SUMSQ(array)))