- Document Solutions for Excel, .NET Edition Overview
- Key Features
- Getting Started
- Features
- Templates
- Formula Reference
- File Operations
- Document Solutions Data Viewer
- API Reference
- Release Notes
BYCOL
This function applies a 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)))