Generate a list of numbers with Excel’s new Sequence function

Microsoft recently introduced a new Excel function called Sequence. It will generate a list of numbers in a sequence that you define. The function has one required argument and three optional arguments, and it’s easier to show than describe…….

By default, it will create a column, starting with 1. In any cell, enter this formula:
=SEQUENCE(8)

With the three optional arguments, you can create a sequence across columns, start with a number other than 1, and increment by any amount, not just by 1. The full syntax is:
=SEQUENCE (rows, [columns], [start], [step])

Let’s say we want 8 rows, go across 4 columns, start with 10 and increment by 5. The function would be:
=SEQUENCE(8,4,10,5)

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Get in touch