Drop down per 4 values

[wjeil]

Hello,

I want to drop down these colum till 75. But it has to add 1 per 4 rows. Does someone know how?

Config4.12.xlsm
	E
4	BATCH 1
5	BATCH 2
6	BATCH 2
7	BATCH 2
8	BATCH 2
9	BATCH 3
10	BATCH 3
11	BATCH 3
12	BATCH 3
13	BATCH 4
14	BATCH 4
15	BATCH 4
16	BATCH 4
17	BATCH 5
18	BATCH 5
19	BATCH 5
20	BATCH 5
21	BATCH 6
22	BATCH 6
23	BATCH 6
24	BATCH 6
Batching Strategy

 

[mikerickson]

="BATCH"&CEILING(ROW(A1),4)/4