Series Number Combine Text Using Custom Number Format

[muhammad susanto]

hi all.

i,m looking for a formula in Custom Number Format to make series number with text like this:

Book1
	D	E
3	data given	expected result
4	frans	1) frans
5	deta	2) deta
6	qimo	3) qimo
7	johny	4) johny
8	merry	5) merry
9		1) frans
10		2) deta
11		3) qimo
12		4) johny
13		5) merry
14		1) frans
15		2) deta
16		3) qimo
17		4) johny
18		5) merry
Sheet1

anyone give me figure out this problem, thank in advance

susant

 

[jdellasala]

Custom Formats can't count. However, since you have 365, a single cell formula will do it:

Book1
	A	B	C
1	data given	expected result	Single Cell Formula
2	frans	1) frans	1) frans
3	deta	2) deta	2) deta
4	qimo	3) qimo	3) qimo
5	johny	4) johny	4) johny
6	merry	5) merry	5) merry
7		1) frans	1) frans
8		2) deta	2) deta
9		3) qimo	3) qimo
10		4) johny	4) johny
11		5) merry	5) merry
12		1) frans	1) frans
13		2) deta	2) deta
14		3) qimo	3) qimo
15		4) johny	4) johny
16		5) merry	5) merry
Sheet1

Cell Formulas
Range	Formula
C2:C16	C2	=LET(ary,SEQUENCE(COUNTA(A2:A6))&") "&A2:A6, VSTACK(ary,ary,ary))
Dynamic array formulas.