- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
-
Functions A to C
- ABS
- ACCRINT
- ACCRINTM
- ACOS
- ACOSH
- ACOT
- ACOTH
- ADDRESS
- AGGREGATE
- AMORDEGRC
- AMORLINC
- ANCHORARRAY
- AND
- ARABIC
- AREAS
- AREASPARKLINE
- ARRAYTOTEXT
- ASC
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BAHTTEXT
- BASE
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BETA.DIST
- BETA.INV
- BETADIST
- BETAINV
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BINOM.DIST
- BINOM.DIST.RANGE
- BINOM.INV
- BINOMDIST
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
- BOXPLOTSPARKLINE
- BULLETSPARKLINE
- BYCOL
- BYROW
- CASCADESPARKLINE
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CHISQ.TEST
- CHITEST
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COLUMNSPARKLINE
- COMBIN
- COMBINA
- COMPLEX
- CONCAT
- CONCATENATE
- CONFIDENCE
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONVERT
- CORREL
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVAR
- COVARIANCE.P
- COVARIANCE.S
- CRITBINOM
- CSC
- CSCH
- CUMIPMT
- CUMPRINC
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
- Functions T to Z
-
Functions A to C
CHOOSEROWS
The function returns the specified rows from an array.
Syntax
=CHOOSEROWS(array,row_num1,[row_num2],…)
Arguments
The function provides the following arguments:
Argument | Description |
|---|---|
array | Refers to the array containing the rows to be returned. |
row_num1 | Refers to the first row number to be returned. |
[row_num2] | [Optional] Refers to the additional row numbers to be returned. |
Remarks
The function returns a #VALUE error if the absolute value of any of the row_num arguments is zero or exceeds the number of rows in the array.
Data Types
The function returns an array,the type of each value in the array depends on the parameter.
Examples
Version Available
This function is available in product version 16.0 or later.
!type=note
Note: The CHOOSEROWS function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.