How to Use CHOOSEROWS Function in Google Sheet


In the realm of spreadsheet management, Google Sheets stands out as a versatile tool for organising and analysing data. One of its powerful functions is CHOOSEROWS, which enables users to dynamically select rows based on specific criteria. This guide will walk you through the intricacies of this function, ensuring you can leverage it to its fullest potential.

Understanding the CHOOSEROWS Function


The CHOOSEROWS function in Google Sheets is a dynamic tool that allows you to select rows from a given range based on certain conditions. This can be immensely useful in scenarios where you need to filter and work with specific data subsets.


CHOOSEROWS operates by evaluating a set of conditions and returning rows that meet those criteria. It takes two main arguments: the range of data to analyse and the conditions to apply. This function provides a flexible approach to data manipulation.

The CHOOSEROWS function in Google Sheet is used to extract specific rows from an array or range. It returns an array of the specified rows in the order they are provided as arguments.

How to insert the CHOOSEROWS function in Google Sheets:

There are few steps to follow for inserting the ‘CHOOSEROWS’ function in Google sheets.

  • Type “=CHOOSEROWS” or go to “Insert” “Function”“Array”“CHOOSEROWS”.
How To Insert The Chooserows Function In Google Sheets
How To Insert The Chooserows Function In Google Sheets


CHOOSEROWS(array, row_num1, [row_num2])

  • array: The array that contains the rows to be returned.
  • row_num1: The row number of the first row to be returned.
  • row_num2…: [ OPTIONAL ] The row number(s) of additional row(s) to be returned.


1. Example: 

Simple data extraction operation with CHOOSEROWS

Input this formula in cell H3: =CHOOSCOLS(A1:F15,1,2,3,6,9,11)

Step 1: Open Your Google Sheet: Launch Google Sheets and open the spreadsheet containing the data you want to work with.

Open Your Google Sheet
Open Your Google Sheet

Step 2: Select a Cell and Enter the Function: Choose the cell where you want the filtered data to appear. Type =CHOOSEROWS(range, conditions) into the selected cell, replacing ‘range’ with the data range you’re evaluating and ‘conditions’ with the specific criteria.

Select A Cell And Enter The Function
Select A Cell And Enter The Function

Step 3: Specify Rows and Columns

Specify Rows And Columns
Specify Rows And Columns

Step 4: Press Enter: Hit the Enter key to apply the function. The selected rows will now be displayed based on the provided conditions.

2. Example:

Simple data extraction with CHOOSEROWS selecting rows ranked from the bottom

Input this formula in G1: =CHOOSEROWS(A1:E8,2,-1,-2,-3,-3,-3))    

How To Use Chooserows Function In Google Sheet

Tips for Optimization:

Understand Your Data Structure:
  • Before applying CHOOSEROWS, have a clear understanding of your dataset. Know the range of data you’re working with and the specific conditions you want to apply.
Use Descriptive Conditions:
  • Craft conditions that accurately capture the criteria you need. Clear and descriptive conditions make it easier to interpret and maintain your formulas.
Combine with Other Functions:
  • Explore integration with other Google Sheets functions to enhance data manipulation. For example, use SUM or AVERAGE in conjunction with CHOOSEROWS to perform more complex operations.
Test and Debug Iteratively:
  • Apply the function incrementally and check the results at each step. This helps identify any discrepancies and ensures that the function is working as intended.
Leverage Named Ranges:
  • Use named ranges to assign labels to specific data ranges. This can make formulas more readable and maintainable, especially in complex spreadsheets.
Avoid Overly Complex Formulas:
  • While CHOOSEROWS is powerful, overly complex formulas can be difficult to manage. Break down complex operations into smaller, more manageable steps.
Document Your Formulas:
  • Add comments or annotations to your formulas to explain their purpose. This makes it easier for others (or even yourself in the future) to understand the logic.
Consider Dynamic Criteria:
  • Use cell references or dynamic criteria that can be easily updated. This allows for more flexibility in your data filtering.
Optimise for Performance:
  • Be mindful of spreadsheet performance, especially with large datasets. Avoid unnecessary calculations and consider using array formulas when appropriate.
Stay Updated on Google Sheets Features:
  • Google Sheets continually evolves, and new features may offer more efficient ways to achieve your data management goals. Stay informed about updates and enhancements.
Seek Community Support:
  • Online forums and communities often have valuable insights and solutions to common challenges. Don’t hesitate to seek advice from fellow Google Sheets users.

Real-World Application:

Financial Analysis and Reporting
  • Professionals in finance and accounting can utilise the CHOOSEROWS function to streamline their data analysis processes. For instance, they can use it to filter out specific transactions or entries based on predefined criteria. This enables them to generate customised reports tailored to specific requirements.
Inventory Management
  • Businesses dealing with inventory management can benefit from this guide. They can apply the CHOOSEROWS function to efficiently track and manage their stock levels. For example, they can filter items based on factors like expiration dates, stock levels, or specific product categories.
Sales and Customer Relationship Management
  • Sales teams can use the CHOOSEROWS function to segment customer data. This can be particularly helpful in targeted marketing campaigns or assessing the performance of specific products or services. By filtering data based on criteria like purchase history or customer demographics, sales teams can make more informed decisions.
Project Management
  • Project managers can employ the CHOOSEROWS function to track progress and allocate resources effectively. They can filter tasks based on priority, deadlines, or other project-specific parameters. This allows for better resource allocation and ensures that critical tasks are addressed promptly.
Human Resources and Recruitment
  • HR professionals can leverage the CHOOSEROWS function for talent acquisition and management. For instance, they can filter job applicant data based on qualifications, experience, or specific skills required for a position. This streamlines the recruitment process and ensures that candidates align with the job requirements.
Research and Data Analysis
  • Researchers and analysts can use the CHOOSEROWS function to extract relevant information from large datasets. By applying specific criteria, they can narrow down the data to focus on the variables of interest. This facilitates more accurate and efficient data analysis.
Marketing and Campaign Optimization
  • Marketing professionals can apply the CHOOSEROWS function to segment their target audience. This allows for the customization of marketing campaigns based on factors like demographics, behaviour, or engagement levels. Tailoring campaigns in this manner can lead to higher conversion rates and better ROI.
E-commerce and Online Retail
  • E-commerce businesses can use the CHOOSEROWS function to manage product listings and inventory. They can filter products based on attributes like availability, popularity, or customer reviews. This ensures that the most relevant and in-demand products are prominently featured.
Educational Institutions and Academic Research
  • Educators and researchers can employ the CHOOSEROWS function for data-driven decision-making. For example, they can filter student performance data based on grades, attendance, or other relevant metrics. This allows for targeted interventions to support struggling students.
Healthcare and Medical Records Management
  • Healthcare professionals can use the CHOOSEROWS function to filter patient records based on specific medical conditions, treatments, or demographics. This aids in generating customised treatment plans and conducting research studies.


Mastering the CHOOSEROWS function in Google Sheets equips individuals and professionals with a powerful tool for efficient data management and analysis. By following this comprehensive guide, you now have the knowledge to tackle complex data filtering tasks with confidence. Embrace the potential of CHOOSEROWS and elevate your productivity in spreadsheet endeavours.

Frequently Asked Questions:

1. Can I use CHOOSEROWS with multiple conditions?
Yes, CHOOSEROWS supports multiple conditions, allowing for complex data filtering.
2. Is CHOOSEROWS case-sensitive?
No, CHOOSEROWS is not case-sensitive, making it flexible for various data scenarios.
3. Can I combine CHOOSEROWS with other functions?
Absolutely, CHOOSEROWS can be integrated with other Google Sheets functions to create advanced data manipulation workflows.
4. How do I update the conditions for CHOOSEROWS?

Simply edit the conditions within the function to dynamically adjust the selected rows.

5. Is CHOOSEROWS available in all versions of Google Sheets?
Yes, CHOOSEROWS is a standard function in Google Sheets and is accessible in all versions.
6. Can I nest CHOOSEROWS functions?
Yes, you can nest CHOOSEROWS functions to perform successive data filtering operations.
Avatar Of Deepak Vishwakarma
Deepak Vishwakarma


gfhgfjgfjgfj j jfgh jgfjgf jgfjgf jfggfhgfjgfjgfj j jfgh jgfjgf jgfjgf gfhgfjgfjgfj j jfgh jgfjgf jgfjgf jfggfhgfjgfjgfj j jfgh jgfjgf jgfjgf jfg

RELATED Articles

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.