# Excel SEQUENCE Function

The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be one dimensional, or two-dimensional. Start and step values are arguments.

**rows**- Number of rows to return.**columns**- [optional] Number of columns to return.**start**- [optional] Starting value (defaults to 1).**step**- [optional] Increment between each value (defaults to 1).

The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be one dimensional, or two-dimensional, controlled by **rows** and **columns** arguments. **Start** and **step** (increment) values are also supplied as arguments. In the example shown, the formula in B4 is:

=SEQUENCE(10,5,0,3)

With this configuration, SEQUENCE returns an array of sequential numbers, 10 rows by 5 columns, starting at zero and incremented by 3. The result is 50 numbers starting at 0 and ending at 147, as shown in the screen.

To return 10 numbers in one column, starting at -5 and ending at 5, incremented by 1:

=SEQUENCE(10,1,-5,1)