# BYCOL

## Content

This function applies a [LAMBDA](/document-solutions/java-excel-api/docs/online/formula-reference/logical-functions/lambda) to each column and returns an array of the results.

## Syntax

`BYCOL(array, lambda(column))`

## Arguments

| **Argument** | **Description** |
| -------- | ----------- |
| *array* | [Required] An array to be separated by column. |
| *lambda* | [Required] A LAMBDA that takes a column as a single parameter and calculates one result. The LAMBDA takes a single parameter. |
| *column* | [Required] A column from array. |

## Remarks

* 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

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