Exceljet

Quick, clean, and to the point

Excel SEQUENCE Function

Excel SEQUENCE function
Summary 

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.

Purpose 
Get array of list of seuential numbers
Return value 
Array of sequential values
Syntax 
=SEQUENCE (rows, [columns], [start], [step])
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).
Usage notes 

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)
SEQUENCE is a new function available in Excel 365 only.