Generate a number sequence with SEQUENCE
IntermediateSEQUENCE is a dynamic array function that builds numbered lists and grids from a single formula. It is useful when you need repeatable IDs, invoice batches, or planning layouts without typing each value by hand.
SEQUENCE uses this structure:
=SEQUENCE(rows, [columns], [start], [step])
The rows argument controls how tall the spill range is. The optional columns argument makes the result spill across as well as down. The optional start and step arguments let you begin at a specific value and count by a custom interval.
For example, a 3 by 2 block that starts at 100 and increases by 5 could use:
=SEQUENCE(3, 2, 100, 5)
In this sheet, each section uses the same function in a slightly different way. Read the shape of each target area first, then decide which optional arguments you need. The next invoice batch must begin at 5001, and the floor plan should count by 10s so there is room to insert more table numbers later.
Your task:
Use SEQUENCE to fill the three highlighted outputs:
- Enter one formula in B2 that spills month IDs for the twelve months listed in A2:A13.
- Enter one formula in E2 that spills six invoice numbers for the clients in D2:D7, starting at 5001.
- Enter one formula in B16 that spills a 4 by 5 table-number grid through F19, counting by 10 each time.
Need some help?
Hint 1
Two sections spill down one column, but the floor plan spills across five columns as well as down four rows.
Hint 2
For the invoice block, count the six client rows first, then use the start argument so the first spilled value is 5001.
Hint 3
The floor plan should fill the highlighted 4 by 5 rectangle starting in B16, and the step argument should increase each value by 10 instead of 1.
Generate a number sequence with SEQUENCE
IntermediateSEQUENCE is a dynamic array function that builds numbered lists and grids from a single formula. It is useful when you need repeatable IDs, invoice batches, or planning layouts without typing each value by hand.
SEQUENCE uses this structure:
=SEQUENCE(rows, [columns], [start], [step])
The rows argument controls how tall the spill range is. The optional columns argument makes the result spill across as well as down. The optional start and step arguments let you begin at a specific value and count by a custom interval.
For example, a 3 by 2 block that starts at 100 and increases by 5 could use:
=SEQUENCE(3, 2, 100, 5)
In this sheet, each section uses the same function in a slightly different way. Read the shape of each target area first, then decide which optional arguments you need. The next invoice batch must begin at 5001, and the floor plan should count by 10s so there is room to insert more table numbers later.
Your task:
Use SEQUENCE to fill the three highlighted outputs:
- Enter one formula in B2 that spills month IDs for the twelve months listed in A2:A13.
- Enter one formula in E2 that spills six invoice numbers for the clients in D2:D7, starting at 5001.
- Enter one formula in B16 that spills a 4 by 5 table-number grid through F19, counting by 10 each time.
Need some help?
Hint 1
Two sections spill down one column, but the floor plan spills across five columns as well as down four rows.
Hint 2
For the invoice block, count the six client rows first, then use the start argument so the first spilled value is 5001.
Hint 3
The floor plan should fill the highlighted 4 by 5 rectangle starting in B16, and the step argument should increase each value by 10 instead of 1.