Google Sheets Function: BYROW

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

Prerequisite: understand the LAMBDA function.

Usage:

=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:

=BYROW(B2:D11

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

=BYROW(B2:D11;LAMBDA(rates

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

=BYROW(B2:D11;LAMBDA(rates;MIN(rates)))

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.