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:
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: