Excel 365 Sequence Function

Everyone knows the trick to creating a sequence of number in Microsoft Excel.  Start the sequence and then select it and drag down the column (or rows) creating the sequence of numbers.

       

 

However, in the Office 365 version of Microsoft Excel there is a new dynamic array formula

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

Positive sequence 1 to 20 example

Negative sequence 20 to 1 example

Positive sequence 1 to 6 across columns

Sequence of 20 days ascending

Sequence of the months of the year

Sequence of numbers across 10 rows and 5 columns starting at 0 and stepping by 3

Last one - Sequence of numbers 1 to 20 with a prefix AND the number only shows if there is an item in the B column

="No. "&SEQUENCE(COUNTA(B:B))