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.