How to use the SEQUENCE function

The Excel SEQUENCE function generates a sequential array of numbers, eliminating the need to use ROW or COLUMN functions for creating arrays for other calculations.

rows  Here you specify the number of rows to be returned.

columns is optional and specifies the number of columns to be returned. If omitted it will return 1 column.

start is optional and specifies the first number in the sequence. If omitted it will start at 1.

step is optional and specifies the increment for each subsequent value in the array. If omitted it will increment by 1.

In our example, we want 1 column with 10 rows of numbers starting at 0 and incrementing by 10 each row

The SEQUENCE function in Excel allows you to generate a sequence of numbers that can spill into multiple columns. This is accomplished by specifying the number of columns in the “column” argument of the function.

With the SEQUENCE function in Excel, you have the flexibility to start the sequence at any number, even zero or a fraction, and increment the values by fractions as well. This allows for precise control over the sequence of numbers generated.

Sequences can be counted in reverse by using a negative value in the step argument, as demonstrated below:

The SEQUENCE function is a member of the newer Excel Dynamic Arrays family. Please note that Dynamic Arrays are currently only available in Office 365 and are in beta on the Insiders channel. It is important to mention that Excel 2019 does not include Dynamic Array functions.

Share to social media