Returns the specified rows from an array.
Syntax
CHOOSEROWS(array, row_num1, [row_num2], ...)Argumente
arrayerforderlich
The array containing the rows to return.
row_num1erforderlich
The index of the first row to return.
row_num2optional
Additional row indices to return.
The CHOOSEROWS function extracts specific rows from a given array or range based on the row numbers provided. It is a dynamic array function that returns a new array containing only the selected rows in the order specified.
=CHOOSEROWS(A1:C3, 1, 3)→Returns the first and third rows of the range A1:C3.This extracts the first and third rows from the specified 3-row range.
Select the target range
Identify the array or cell range you want to extract rows from.
Input row numbers
Enter the function followed by the array and the specific row numbers you wish to retrieve.
Yes, negative numbers count from the end of the array (e.g., -1 is the last row).