CHOOSEROWS is a function that allows you to choose and return only specific rows from a range/array. The result returns as a dynamic array.
CHOOSEROWS is a new Excel function – It’s available for Excel 365 and Excel for the Web.
=CHOOSEROWS(array, row_num1, [row_num2], …)
array – The range/array from which we want to return only a specific row (or rows).
row_num1 – The number of the first row we want to return.[row_num2] – The number of the second row we want to return. This is an optional argument – Use it if you need to return more than one row from your array. Type additional row numbers separated by commas to include additional rows in the returned array.
Cool stuff to know about CHOOSEROWS:
- You can type negative numbers in the row_num arguments, to return rows from the end of the range. For example, if we wish to return the second to last row of the range, we can do it by typing -2 (minus 2):
- You can ask CHOOSEROWS to repeat a certain row more than once, by typing the row number again:
Let’s put our knowledge into practice and practice the CHOOSEROWS function!