Excel 365 + Google Sheets · SEQUENCE
Number any list instantly
Generates a list of numbers: 1, 2, 3... as many as you need.
The formula
=SEQUENCE(5)What each part means
5How many numbers
Example
| A | B | |
|---|---|---|
| 1 | # | Task |
| 2 | Invoices | |
| 3 | Payroll | |
| 4 | Report | |
| 5 | Audit | |
| 6 | Website |
| A | B | |
|---|---|---|
| 1 | # | Task |
| 2 | 1 | Invoices |
| 3 | 2 | Payroll |
| 4 | 3 | Report |
| 5 | 4 | Audit |
| 6 | 5 | Website |
Step by step
- Click cell A2.
- Type the formula:
=SEQUENCE(5) - Press Enter.
- The results fill the cells below by themselves (it’s a dynamic array formula). Don’t type anything in them.
Where it works
- Excel 365 and Excel 2021 or newer
- Google Sheets
- Excel for the web (free)