BYCOL
Applies lambda to each column of array.
- Excel: Verified match
- Google Sheets: Verified match
- Returns: Array
Examples
=BYCOL(A1:C3, LAMBDA(col, MAX(col))) | A | B | C | |
|---|---|---|---|
| 1 | 10 | 2 | alpha |
| 2 | 20 | 4 | beta |
| 3 | 30 | 6 | gamma |
Result 30
Syntax
BYCOL(array, lambda)array- range required
lambda- any required
Errors
#ERROR!=BYCOL(A2:A3)
Related
ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array. CHOOSEROWSReturns the specified rows from an array.