- 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
- ABS
- ACOS
- ACOSH
- ACOT
- ACOTH
- AGGREGATE
- ARABIC
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- BASE
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- COMBIN
- COMBINA
- COS
- COSH
- COT
- COTH
- CSC
- CSCH
- DECIMAL
- DEGREES
- EVEN
- EXACT
- EXP
- FACT
- FACTDOUBLE
- FLOOR.MATH
- FLOOR.PRECISE
- GCD
- INT
- ISO.CEILING
- LCM
- LET
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- MUNIT
- ODD
- PI
- POWER
- PRODUCT
- QUOTIENT
- RADIANS
- RAND
- RANDARRAY
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SEC
- SECH
-
SEQUENCE
- SERIESSUM
- SIGN
- SIN
- SINH
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- TRUNC
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
SEQUENCE
SEQUENCE function returns a list of sequential numbers in an array (in ascending order), such as 1, 2, 3, 4, and so on. This function is used with hard-coded arguments to allow users to generate a specific sequence of values for the dynamic array formula.
Syntax
SEQUENCE(rows,[columns],[start],[step])
Arguments
SEQUENCE function has the following arguments:
Argument | Description |
|---|---|
rows | [required] Specifies the number of rows to generate in the sequence. Users must specify this argument. If this argument is not provided, the #CALC! error will be returned. |
columns | [optional] Specifies the number of columns to generate in the sequence. If this argument is provided, the function returns an array with the specified number of columns. If nothing is specified, then the default value 1 is used. |
start | [optional] Specifies the starting value. If this argument is provided, the function returns values starting with the specified value. In case nothing is specified by the user, then the default value 1 is used. |
step | [optional] Specifies the increment value. If this argument is provided, the function returns values incremented with that specified value. In case nothing is specified by the user, then the default value 1 is used. |
Data Types
Accepts the number of rows and columns. Returns a sequence of numbers.
Examples
For instance - Cell A2 in the following image contains the formula "=SEQUENCE(4,5)" and returns an array with values spilled to a cell range containing four rows and five columns displaying numbers in the sequence 1, 2, 3, 4 up to 20.
Version Available
This function is available in SpreadJS 13 or later.