Sequence

Using the Excel SEQUENCE Function

Summary

The Excel SEQUENCE function generates a list of sequential numbers (i.e. 1, 2, 3, 4) in a one- or two-dimensional array.

The SEQUENCE function is a beta feature and is currently only available to Office Insiders as of this writing.


Syntax

=SEQUENCE (rows, [columns], [start], [step])

Syntax Breakdown

Rows
Required. The number of rows to be returned.

Columns
Optional. The number of columns to be returned.

Start
Optional. First number in the sequence.

Step
Optional. Amount to increase each subsequent value in the sequence. Enter as a negative value to decrease each subsequent value.


Usage Notes

SEQUENCE generates a list of sequential numbers in an array. Row and column arguments control whether the array is one- or two-dimensional.

Omitting any of the optional arguments (columns, start, step) will result in that value defaulting to one.

If you are creating a dynamic array between workbooks the both workbooks must remain open. If the source workbook is closed then the linked dynamic array will return #REF! when refreshed.