Create a list of dates with a formula
=SEQUENCE(B2,1,B1,1)Excel · result on the sample sheet: 14 rows (D2:D15)
Describe what you need and get a working SEQUENCE formula for Excel and Google Sheets, tested on real data before you copy it. SEQUENCE generates a list or grid of numbers from one formula: 1 to 10, every fifth number, or a countdown.
Each formula below was calculated on its own sample sheet. Open one to see the sheet, why it works, and to try it yourself.
=SEQUENCE(B2,1,B1,1)Excel · result on the sample sheet: 14 rows (D2:D15)
=SEQUENCE(B2,1,B1,14)Excel · result on the sample sheet: 8 rows (D2:D9)
=SEQUENCE(B1,1,B2,B3)Excel · result on the sample sheet: 10 rows (D2:D11)
=SEQUENCE(B2-B1+1,1,B1)Excel · result on the sample sheet: 8 rows (D2:D9)
=A3:A12*B2:K2Excel · result on the sample sheet: 10 rows (B3:K12)
=EDATE(B1,SEQUENCE(B2,1,0))Excel · result on the sample sheet: 12 rows (D2:D13)
=CHAR(SEQUENCE($D$1,1,CODE($F$1)))Excel · result on the sample sheet: 26 rows (A2:A27)
=SUMPRODUCT(LARGE(B2:B11,{1,2,3}))/SUM(B2:B11)Excel · result on the sample sheet: 62.2%
You describe the task in plain English, and it writes the formula, using SEQUENCE where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.
SEQUENCE generates a list or grid of numbers from one formula: 1 to 10, every fifth number, or a countdown.
Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the SEQUENCE function page has a practice exercise.