SheetFX
≡
<< Go back to all functions

CHOOSEROWS

The CHOOSEROWS function in Google Sheets allows you to create a new array by selecting specific rows from an existing range. This function is very useful when you need to extract specific data from a larger dataset. Learn how to use CHOOSEROWS effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: CHOOSEROWS(array, row_num1, [row_num2])

Parameters:

  • array: The range of cells from which to select rows.
  • row_num1: The number of the first row to include in the new array.
  • row_num2: [Optional] The number of the last row to include in the new array. If not provided, row_num1 is used as the last row.

Step-by-Step Tutorial

  1. Using CHOOSEROWS with a single row:

    • Example: If A1:C5 contains a range of data, =CHOOSEROWS(A1:C5, 2) will create a new array containing the second row of the original range.

  2. Using CHOOSEROWS with multiple rows:

    • Example: If A1:C5 contains a range of data, =CHOOSEROWS(A1:C5, 1, 3) will create a new array containing the first three rows of the original range.

Use Cases and Scenarios

  1. Data Extraction: Extract specific rows from a large dataset for further analysis.
  2. Data Filtering: Filter out unwanted rows based on certain criteria.
  3. Data Consolidation: Combine selected rows from multiple ranges into a single array.

Related Functions

  • CHOOSE: Selects an item from a list based on its index.
  • FILTER: Filters a range of data based on specified conditions.

Related Articles