BYCOL
Applies a LAMBDA to each column and returns an array of the results.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
What it does
Applies a custom LAMBDA calculation to each column in an array and returns the results as a single row.
Syntax
BYCOL(array, lambda)
Arguments
array(array) — The array to process.lambda(function) — A LAMBDA function that takes a column as input and returns a single result.
Examples
Max value per column
Find the maximum value in each column.
FORMULA
=BYCOL(A1:C3, LAMBDA(col, MAX(col)))
RESULT
[10, 20, 30]
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | A | B | C |
| 2 | 1 | 15 | 5 |
| 3 | 10 | 2 | 30 |
| 4 | 5 | 20 | 10 |