Formulas > =BYROW()

How To Use BYROW() Function in Google Sheets


Groups an array by rows by application of a LAMBDA function to each row.

Common questions about the BYROW formula include:

• What does the BYROW formula do?
• How can the BYROW formula be used?
• What are the parameters of the BYROW formula?
The BYROW formula can be used appropriately to copy a column of cells and paste the contents of these cells in another sheet. It can be used to determine the number of values in a row and copy all the data from one sheet to another.

The BYROW formula can be commonly mistyped as the following:

Common ways the BYROW formula is often used inappropriately include:
• Using the BYROW formula to copy cells across worksheets.
• Using the BYROW formula to extend a range beyond the intended value.
• Using the BYROW formula without adding parameters.

Common pitfalls when using the BYROW formula include:
• Not specifying a range for the BYROW formula to apply
• Not understanding the range limits before using the BYROW formula
• Not including the row parameter; BYROW formula requires both column and row parameters to be specified

Common mistakes when using the BYROW Formula include:
• Copying data from the wrong worksheet
• Copying data into the wrong worksheet
• Misunderstanding the parameters of the BYROW formula

Common misconceptions people might have with the BYROW Formula include:
• Thinking that BYROW formula only works on columns when it can be used to both rows and columns 
• Thinking the BYROW formula only works on a single worksheet when it can be used across multiple worksheets 
• Thinking the BYROW formula can only be used to copy cells when it can also be used to create a range of values.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

There are no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

How To Actually Use BYROW() in Sheets

BYROW(array_or_range, LAMBDA)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the BYROW() formula:

Generate a BYROW() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.