[]
        
(Showing Draft Content)

BYROW

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

Syntax

BYROW(array, lambda(row))

Arguments

Argument

Description

array

[Required] An array to be separated by row.

lambda

[Required] A LAMBDA that takes a row as a single parameter and calculates one result. The LAMBDA takes a single parameter.

row

[Required] A row from array.

Remarks

  • Providing an invalid LAMBDA function or an incorrect number of parameters returns a #VALUE! error called "Incorrect Parameters".

  • Not providing a LAMBDA function or anything but a single value returned from the LAMBDA function returns a #CALC error.

Examples

BYROW(A1:C2, LAMBDA(array, MAX(array)))