How to Generate a Sequential List of Numbers or Dates in Excel?
Generate Sequential Numbers is a Excel function that generates a vertical array of sequential numbers starting from 1 up to 100.. Formula Genius generates and validates this formula automatically from a plain-English prompt.
Creating a sequence of numbers or dates in Excel can simplify data entry and organization. This guide shows you how to do it easily.
The Formula
"Generate a sequential list of numbers from 1 to 100, or generate dates for each day of a month"
=SEQUENCE(100, 1, 1, 1)This formula generates a vertical array of sequential numbers starting from 1 up to 100.
Step-by-Step Breakdown
- SEQUENCE is the function used to create a list of sequential numbers.
- The first argument (100) specifies the total number of rows to generate.
- The second argument (1) specifies the number of columns.
- The third argument (1) is the starting number of the sequence.
- The fourth argument (1) indicates the increment between each number.
Edge Cases & Warnings
- Generating a sequence with a starting number greater than the ending number.
- Using a negative increment which results in an empty array.
- Specifying a zero for the number of rows, which returns an empty array.
- Trying to generate a sequence beyond Excel's row limit.
Examples
"Generate numbers from 1 to 10"
1, 2, 3, 4, 5, 6, 7, 8, 9, 10"Generate dates for each day of March 2023"
03/01/2023, 03/02/2023, ..., 03/31/2023Frequently Asked Questions
Can I change the starting number?
Yes, modify the third argument in the SEQUENCE function.
How do I generate a sequence of dates?
Use the SEQUENCE function with a date increment.
What happens if I exceed the row limit?
Excel will return an error if the sequence exceeds available rows.
Can't find what you need?
Describe any formula in plain English and Formula Genius will generate, explain, and validate it — instantly.