The Excel SEQUENCE function helps us to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. In MS-Excel SEQUENCE function is categorized under MATH & TRIGNOMETRY function.
Purpose of Excel SEQUENCE Function
It helps replace the need to use the ROW or COLUMN function to return an array of values for use in other functions. rows Here we need to specify the number of rows to be returned.
Return value
SEQUENCE function returns an array of sequential functions.
Syntax
=SEQUENCE(rows,[columns],[start],[step])
Arguments
| Arguments | Description | Remarks |
| rows | The number of rows to return. | Mandatory |
| [columns] | The number of columns to return. If excluded, it will return a single column. | Mandatory |
| [start] | The first number in the sequence. If excluded it will start at 1. | Optional |
| [step] | The amount to increment each subsequent value. If excluded, each increment will be 1. | Optional |
Usage notes
- Any missing optional arguments will default to 1.
- If any of the arguments is not a numeric value, you will get a #VALUE! error.
- This function will return an array, which will spill if it’s the final result of a formula
Availability
Available for office 365.