BYCOL Function

Se aplica a
Excel para Microsoft 365 Excel para Microsoft 365 para Mac Excel 2024 Excel 2024 para Mac

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