Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

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.

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.