Fill series number with different level

[muhammad susanto]

hi all.

how to make series number with different interval
like this.

target/my expected	given/input	fruits
11	10	mango
12	mango
13	mango
14	mango
15	mango
16	mango
21	20	grape
22	grape
23	grape
31	30	banana
32	banana
33	banana
34	banana
35	banana
36	banana

thank in advance.

sst

 

[MARK858]

Maybe...

date file.xlsb
	A	B	C
1	target/my expected	given/input	fruits
2	11	10	mango
3	12	mango
4	13	mango
5	14	mango
6	15	mango
7	16	mango
8	21	20	grape
9	22	grape
10	23	grape
11	31	30	banana
12	32	banana
13	33	banana
14	34	banana
15	35	banana
16	36	banana
Sheet7

Cell Formulas
Range	Formula
A2:A16	A2	=IF(ISNUMBER(B2),B2+1,SUM(A1,1))
C2:C16	C2	=IF(ISNUMBER(B2),B3,"")

 

[muhammad susanto]

hi mark, thank you.

 

[MARK858]

You're welcome