Arrays & ARRAYFORMULA › SEQUENCE43 / 67

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeSEQUENCE

SEQUENCE: consecutive receipt numbers

The treasurer of a school cooperative in Cirebon is preparing a new page of the receipt book. The numbers must continue from the previous page, starting at 1201, and one page holds 10 receipts.

Task

In A2, write one SEQUENCE formula that produces receipt numbers 1201 to 1210 going down (A2:A11).

Cells to fillA2:A11

Required functionsSEQUENCE

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
SEQUENCE builds a series of numbers: SEQUENCE(rows, columns, start, step).
Hint 2
You need 10 rows and 1 column.
Hint 3
The start is 1201 and the step is 1.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

A2

=SEQUENCE(10,1,1201,1)

Explanation

=SEQUENCE(10,1,1201,1) returns 10 rows × 1 column of numbers starting at 1201 with a step of 1, so 1201 to 1210. You can leave out the step because it defaults to 1. Change the step to 5 for numbers that skip. For prefixed numbers, join it with text inside ARRAYFORMULA: =ARRAYFORMULA("KW-"&SEQUENCE(10,1,1201)).

Starting worksheet: Sheet1
Row	A	B	C	D
1	Receipt no.	Date	Received from	Amount
2
3
4
5
6
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result