SEQUENCE Formula in Excel

 

What does it do?

Creates an array of sequential numbers

Formula breakdown:

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

What it means:

=SEQUENCE(number of rows, [number of columns], [starting number], [increment per number])

---

Did you know that you can now generate a series of numbers with an Excel Formula? Yes you can! It is definitely possible now with Excel’s SEQUENCE Formula. It is a new formula introduced in Office 365 released in 2018!

I explain how you can do this below:

STEP 1: We need to enter the SEQUENCE function in a blank cell:

=SEQUENCE(

STEP 2: The SEQUENCE arguments:

rows

How many rows to fill with values?

Let us go for 10 rows.

=SEQUENCE(10,

[columns]

How many columns to fill with values?

Let us go for 3 columns.

=SEQUENCE(10, 3,

[start]

Which number do you want the sequence of numbers to start?

Let us have it start at the number 10.

=SEQUENCE(10, 3, 10,

[step]

Which increment for each number in the sequence?

Let us increment it by 100. So that numbers should look like: 10, 110, 210, 310, and so on…

=SEQUENCE(10, 3, 10, 100)

Try it out now and see that your sequence of numbers is generated magically!

 

How to Use the SEQUENCE Formula in Excel