BYROW function
Summary
Applies a LAMBDA to each row and returns an array of the results
Syntax
BYROW(array, lambda(row))
The BYROW function syntax has the following arguments:
• array An array to be separated by row.
• lambda A LAMBDA that takes a row as a single parameter and calculates one result. The LAMBDA takes a single parameter:
• row A row from array.
• array An array to be separated by row.
• lambda A LAMBDA that takes a row as a single parameter and calculates one result. The LAMBDA takes a single parameter:
• row A row from array.
Example
=BYROW(A1:C2, LAMBDA(array, MAX(array)))
=BYROW(A1:C2, LAMBDA(array, SUMSQ(array)))
=BYROW(A1:C2, LAMBDA(array, SUMSQ(array)))