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)