# 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.

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/8z8image.png) ](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/8z8image.png)[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/nkNimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/nkNimage.png)

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

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/rrAimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/rrAimage.png)

##### Negative sequence 20 to 1 example

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/UGGimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/UGGimage.png)

##### Positive sequence 1 to 6 across columns

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/taQimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/taQimage.png)

##### Sequence of 20 days ascending

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/Z23image.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/Z23image.png)

##### Sequence of the months of the year

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/kJbimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/kJbimage.png)

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

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/63aimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/63aimage.png)

##### 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))

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/YFbimage.png) ](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/YFbimage.png)[![mHLimage.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/mhlimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/mhlimage.png)