How do I create an auto serial numbering according to the alphabet's formula value?

[NARESH SHINDE]

How do I create an auto serial numbering according to the text value?
example is
Colme A Colme B
A 1
A 2
A 3
A 4
A 5
B 1
B 2
B 3
B 4
B 5
B 6
B 7
B 8
C 1
C 2
C 3
C 4
D 1
D 2
Please help me immediately

 

[awoohaw]

Are the letters already there?

Book1
	A	B
1	Column A	Column B
2	A	A 1
3	A	A 2
4	A	A 3
5	A	A 4
6	A	A 5
7	B	B 1
8	B	B 2
9	B	B 3
10	B	B 4
11	B	B 5
12	B	B 6
13	B	B 7
14	B	B 8
15	C	C 1
16	C	C 2
17	C	C 3
18	C	C 4
19	D	D 1
20	D	D 2
Sheet1

Cell Formulas
Range	Formula
B2:B20	B2	=A2&" " & COUNTIF($A$2:A2,A2)

 

[awoohaw]

If the letters are not already there, how do you know how many rows to repeat the letters for?

 

[awoohaw]

If just to repeat the numbers:

Book1
	A	B	C
1	Column A	Column B	If just want numbers:
2	A	A 1	1
3	A	A 2	2
4	A	A 3	3
5	A	A 4	4
6	A	A 5	5
7	B	B 1	1
8	B	B 2	2
9	B	B 3	3
10	B	B 4	4
11	B	B 5	5
12	B	B 6	6
13	B	B 7	7
14	B	B 8	8
15	C	C 1	1
16	C	C 2	2
17	C	C 3	3
18	C	C 4	4
19	D	D 1	1
20	D	D 2	2
Sheet1

Cell Formulas
Range	Formula
B2:B20	B2	=A2&" " & COUNTIF($A$2:A2,A2)
C2:C20	C2	=COUNTIF($A$2:A2,A2)

 

[Fluff]

If your data is always grouped together, another option

Fluff.xlsm
	A	B
1	Column A	Column B
2	A	1
3	A	2
4	A	3
5	A	4
6	A	5
7	B	1
8	B	2
9	B	3
10	B	4
11	B	5
12	B	6
13	B	7
14	B	8
15	C	1
16	C	2
17	C	3
18	C	4
19	D	1
20	D	2
Master

Cell Formulas
Range	Formula
B2:B20	B2	=IF(A2=A1,B1+1,1)