How to Use CHOOSEROWS() in Google Sheets

Description

Creates a new array from the selected rows in the existing range.

How To Actually Use CHOOSEROWS() in Sheets

CHOOSEROWS(array, row_num1, [row_num2, ...])

Try CHOOSEROWS yourself

Use CHOOSEROWS to return rows 1, 2, and 4 from A1:B5. Place the formula in D1.

Your formula

Hints (3)

Locale Separator ,

Official Docs

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 BetterSheets.co/formulas

Transcript-matched member videos for CHOOSEROWS(). Click through to watch.

Watch more tutorials

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.

Intermediate

ARRAYFORMULA() IF() ISBLANK() MAX()

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Create a pastel colored hunting game, just in time for Easter.

Intermediate

COUNTIF() IF()

Unlock these tutorials

Learn more about the CHOOSEROWS() formula:

Generate a CHOOSEROWS() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses CHOOSEROWS(). 2 free AI generations, no signup. Members get unlimited use.

Generate a CHOOSEROWS() formula

How to Use CHOOSEROWS() in Google Sheets

Try CHOOSEROWS yourself

More related tutorials

Calculate ROAS in Google Sheets

Hardest Formula: SumIF | Addition Based on Dates / Values

How to Iterate Counting Blank Cells in Google Sheets

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co