BYCOL Function. Split a cell range by columns and tally by column.(Microsoft Excel)
The BYCOL function is a new function added to Excel in February 2022.
It is a helper function to the LAMBDA function.
It divides a cell range by columns and spills the results by column.
Contents
How it works
=BYCOL(Array, Lambda Function)
| Name | Omission | Explanation |
|---|---|---|
| Array | Required argument. The cell range to be aggregated. This cell range is divided by columns. | |
| Lambda Function | Required argument. Specify the formula to be performed per column. |
Demonstrate
In the following example, if a formula is set in cell B8, the Spill will automatically extend the formula to cells C8 and D8.
=BYCOL(B5:D7, LAMBDA( totalRange, SUM( totalRange + totalRange * A2 ) ) )
---