This function creates a new array from the selected rows in the existing range.
Learn ↓
How To Use CHOOSEROWS()
Description
How To Actually Use CHOOSEROWS() in Sheets
CHOOSEROWS(array, row_num1, [row_num2])
0Better Sheets Tutorials
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.
Learn more about the CHOOSEROWS() formula: