[]
DEMOS BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

BYCOL

This function applies a LAMBDA to each column and returns an array of the results.

Syntax

BYCOL (array, lambda(column))

Argument

This function has the following arguments:

Argument Description
array An array to be separated by row.
lambda A LAMBDA that takes a row as a single parameter and calculates one result. The LAMBDA takes a single parameter: column: A column from array

Remarks

If an invalid LAMBDA function or an incorrect number of parameters are provided, it returns a #VALUE! error called "Incorrect Parameters". Not providing a LAMBDA function or anything but a single value returned from the LAMBDA function returns a #CALC error.

Data Types

Returns numerical value.

Examples

BYCOL(A1:C2, LAMBDA(array, MAX(array))) BYCOL(A1:C2, LAMBDA(array, SUMSQ(array)))

Version Available

This function is available in product version 15 or later.