Why Use SEQUENCE Instead of the Fill Handle? Excel's SEQUENCE function lets you create a list of numbers in a sequence in an instant.

SEQUENCE is the function that will generate the list of numbers, and COUNTA, the first argument of the SEQUENCE formula, will count the number of non-blank cells in the range B2 to B901.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

The sequence function in Google Sheets is easy to use and works with different formats At first glance, the sequence function will seem similar to the fill command when working with sequential data.