Applies a LAMBDA to each column and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 3 columns by 1 row.

Feature available to Office Insiders only This feature is available to Office Insiders only right now.

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.

Errors

Providing an invalid LAMBDA function or an incorrect number of parameters 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.

Examples

Example 1: Return the maximum value of each column

Enter the sample data into cells A1: C2, and then copy the formula into cell D4:

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

First BYCOL function example

Example 2: Return the sum of the squared value of each array element in each column

Enter the sample data into cells A1: C2, and then copy the formula into cell D4:

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

Second BYCOL function example

See Also

MAP function

REDUCE function

SCAN function

MAKEARRAY function

BYROW function

ISOMITTED function

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×