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
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/a-to-z/307/chooserows1.jpg/f905133fcd7cd40839b2a69bf7f8fd87.jpg)
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:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/a-to-z/307/chooserows2.png/60a7646dacaeeb4f1ca5377252d01baa.jpg)
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/a-to-z/307/chooserows4.png/f4da45337478fcb0afc24ca2e3b9c12b.jpg)
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/a-to-z/307/chooserows3.png/1fe96b6037cd515b4293fb98c045125c.jpg)
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/a-to-z/307/chooserows5.png/29f2eb06bafcb6ff91e5cdcf0ce48b28.jpg)
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.