Products, services, and OS functions
may not be available in this country.

BYCOL

The BYCOL function applies a LAMBDA function to each column and returns an array of the results.

BYCOL(array, LAMBDA (parameter, calculation))

array: An array to be separated by columns.

LAMBDA: A defined subformula.

parameter: The identifier for a column.

calculation: The formula you want the function to execute and return. This is required and must be the last argument.

Notes

Examples

Given the following table:

A

B

C

1

3

7

1

2

9

6

2

3

8

5

4

=BYCOL(A1:C3, LAMBDA(parameter, MAX(parameter))) returns 9, 7, 4, which are the maximum values in each column.

=BYCOL( A1:C3, LAMBDA(parameter, SUMPRODUCT(parameter))) returns 20, 18, 7, which are the sumproducts of each column.

See alsoLAMBDABYROW
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.