CHOOSEROWS Function

Description

Returns the specified rows from an array. 

NOTE

• The absolute value of the row_num should be greater than 0 and not exceed the number of rows in the array.
• The returned array has the same width as the original array.

Syntax

Copied!=CHOOSEROWS(array, row_num1, [row_num2],  ...)
=CHOOSEROWS(array, row_num1, [row_num2],  ...)

EXAMPLE

Copied!=CHOOSEROWS(A1:E10, 1, 3, 5, 1)
//𝘵𝘢𝘬𝘦 𝘵𝘩𝘦 𝘧𝘪𝘳𝘴𝘵 𝘢𝘯𝘥 𝘭𝘢𝘴𝘵 𝘳𝘰𝘸
=CHOOSEROWS(A1:E10, 1, -1)
//𝘵𝘢𝘬𝘦 𝘵𝘩𝘦 𝘧𝘪𝘳𝘴𝘵 𝘵𝘩𝘳𝘦𝘦 𝘳𝘰𝘸
=CHOOSEROWS(A1:E10, SEQUENCE(3))
//𝘳𝘦𝘷𝘦𝘳𝘴𝘦 𝘵𝘩𝘦 𝘰𝘳𝘥𝘦𝘳 𝘰𝘧 𝘳𝘰𝘸
=LET(a, A1:E10, c, ROWS(a), CHOOSEROWS(a, SEQUENCE(c, , c, -1)))
=CHOOSEROWS(A1:E10, 1, 3, 5, 1)
//𝘵𝘢𝘬𝘦 𝘵𝘩𝘦 𝘧𝘪𝘳𝘴𝘵 𝘢𝘯𝘥 𝘭𝘢𝘴𝘵 𝘳𝘰𝘸
=CHOOSEROWS(A1:E10, 1, -1)
//𝘵𝘢𝘬𝘦 𝘵𝘩𝘦 𝘧𝘪𝘳𝘴𝘵 𝘵𝘩𝘳𝘦𝘦 𝘳𝘰𝘸
=CHOOSEROWS(A1:E10, SEQUENCE(3))
//𝘳𝘦𝘷𝘦𝘳𝘴𝘦 𝘵𝘩𝘦 𝘰𝘳𝘥𝘦𝘳 𝘰𝘧 𝘳𝘰𝘸
=LET(a, A1:E10, c, ROWS(a), CHOOSEROWS(a, SEQUENCE(c, , c, -1)))

RELATED