BYROW

The BYROW function applies a LAMBDA function to each row and returns an array of the results.

BYROW(array, LAMBDA(parameter, calculation))

array: An array to be separated by rows.

LAMBDA: A defined subformula.

parameter: The identifier for rows.

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

4

1

2

6

7

9

3

2

5

8

=BYROW(A1:C3, LAMBDA(parameter, MAX(parameter))) returns 4, 9, 8, which are the maximum values in each row.

=BYROW( A1:C3, LAMBDA(parameter, SUMPRODUCT(parameter))) returns 8, 22, 15, which are the sumproducts of each row.

See alsoBYCOLLAMBDA
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Kasulik?
Tähemärkide piirang: 250
Maksimaalne tähemärkide piirang on 250.
Täname tagasiside eest.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.