CHOOSEROWS Function Explained
The CHOOSEROWS function in Microsoft Excel allows users to select a subset of rows from a given range of cells. It takes two arguments: array and row_num. The array argument is a range of cells from which the rows will be selected, and the row_num argument is a range of numbers that correspond to the rows in the array argument that should be selected. The CHOOSEROWS function returns an array of the selected rows.
CHOOSEROWS Function Syntax
CHOOSEROWS(data, criteria)
- data: The range of cells that contains the data to be filtered.
- criteria: The criteria used to filter the data.