Google Sheets Function: BYROW

The BYROW function applies a LAMBDA function to each row of the entered table.

Prerequisite: understand the LAMBDA function.


=BYROW(array_or_range, LAMBDA)

Example of use

The objective here will be to list with a single formula the lowest rate of each row:

google sheets best rate calculation byrow

Enter the BYROW function followed by the table containing the data to be processed:


Then add the LAMBDA function and choose a variable name (for example, "rates"):


And finally, add a MIN function to determine the lowest rate:


The BYROW function will then traverse the entered table (B2:D11) row by row and return the smallest value of each row:

google sheets functions byrow lambda min
If needed, you can copy the Google Sheets document (or view the document) with this example.