Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The CHOOSEROWS Function

4 April 2022

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the CHOOSEROWS function.

The CHOOSEROWS function

The CHOOSEROWS function returns the specified rows from an array.  It has the following syntax:  

CHOOSEROWS(array, row number 1, [row number 2, …])

The CHOOSEROWS function has the following arguments:

  • array: this is required and represents the selected array
  • row number 1: this is also required and denotes the row number of the first row to be returned
  • row number 2: this and subsequent arguments are optional.  This / these represent(s) the second and subsequent row numbers to be returned.

It should be noted that Excel will return an #VALUE! error if the absolute value of any of the row number arguments is zero or exceeds the number of rows in the array.

Please see my examples below: 

We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every other business day.

A full page of the function articles can be found here.

Newsletter