You're a scheduling analyst preparing a 12-row template that needs the month numbers 1–12 stacked down a single column. Column A has the header MonthNumber in A1; rows below are empty.
Your task:
- In A2, write a single SEQUENCE formula that produces the numbers 1 through 12 in A2:A13. Don't drag-fill — this is a spill formula: one cell, twelve outputs.
The spill range (A2:A13) must be empty before the formula runs; if any cell in A3:A13 contains content, the formula returns #SPILL! instead of the values. Clear those cells first if you've experimented there.
The classic alternative is twelve hand-typed numbers, or the per-row pattern =ROW()-1 dragged down. SEQUENCE wins both on terseness (one cell, no drag) and on parameterizability (change 12 to 365 for a daily sequence).
Graded cells: A2 (=1), A7 (=6), A13 (=12).
Open this problem on a desktop to attempt it.