- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
CHOOSEROWS
The function returns the specified rows from an array.
Syntax
=CHOOSEROWS(array,row_num1,[row_num2],…)
Argument
This function has 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. |
Data Types
Returns an array, the type of each value in the array depends on the parameter.
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.
Examples
