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
