This function creates a new array from the selected rows in the existing range.
Formulas > =CHOOSEROWS()
How To Use CHOOSEROWS() Function in Google Sheets
Description
How To Actually Use CHOOSEROWS() in Sheets
CHOOSEROWS(array, row_num1, [row_num2])
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
Learn more about the CHOOSEROWS() formula:
Generate a CHOOSEROWS() 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.