The SEQUENCE function in Excel is useful when you need a pattern.
So, it might be as simple as a list of numbers, starting from one, and going up by one. Or, codes for products, that start from 1000, and go up in hundreds. Or, create a list of dates.
=SEQUENCE(rows,[columns],[start],[step])
SEQUENCE has one compulsory input and three optional ones (shown by the square brackets). The first input is the number of rows. If you don’t give the optional inputs, then the columns, start, and step are all assumed to be one. So, you would get a spilled array, of the number of rows you specified, that was one column wide, starting at one, and going up by one each row. Good for giving every row of your data a unique number.
A more interesting use, would be to give a start value of today’s date. This is easily done with the TODAY function. This function doesn’t require any inputs, but you still have to put the () there.
So, we can see here, the function is producing 10 rows, starting with today’s date and showing the next 10 days.
The biggest problem with SEQUENCE, and any formula that producers a spilled array, is that they don’t work inside a table. This is super annoying, because tables are great!