Create a grouping using A,B,C etc

[FryGirl]

As you can see, in column B I found a formula to number the groupings of column A. Not sure if this is the most efficient formula to use, but I would also like to create a grouping of column A, but by letter versus the numbering.

Groupings.xlsb
	A	B	C
1	Name	Number	Letter
2	Apr	1	A
3	Apr	1	A
4	Apr	1	A
5	Aug	2	B
6	Aug	2	B
7	Aug	2	B
8	Aug	2	B
9	Aug	2	B
10	Dec	3	C
11	Dec	3	C
12	Feb	4	D
13	Feb	4	D
14	Feb	4	D
15	Feb	4	D
16	Jan	5	E
17	Jan	5	E
18	Jan	5	E
Sheet1

Cell Formulas
Range	Formula
B2:B18	B2	=IF(COUNTIF(A$2:A2,A2)=1,MAX(B$1:B1)+1,VLOOKUP(A2,A$1:B1,2,0))

 

[JGordon11]

Book1
	A	B	C	D
1	Name	Number	Letter1	Letter2
2	Apr	1	A	A
3	Apr	1	A	A
4	Apr	1	A	A
5	Aug	2	B	B
6	Aug	2	B	B
7	Aug	2	B	B
8	Aug	2	B	B
9	Aug	2	B	B
10	Dec	3	C	C
11	Dec	3	C	C
12	Feb	4	D	D
13	Feb	4	D	D
14	Feb	4	D	D
15	Feb	4	D	D
16	Jan	5	E	E
17	Jan	5	E	E
18	Jan	5	E	E
19
Sheet1

Cell Formulas
Range	Formula
B2:B18	B2	=IF(COUNTIF(A$2:A2,A2)=1,MAX(B$1:B1)+1,VLOOKUP(A2,A$1:B1,2,0))
C2:C18	C2	=IF(ROW()<>2, IF(A2=A1,C1,CHAR(CODE(C1)+1)),"A")
D2:D18	D2	=CHAR(64+B2)

 

[Eric W]

A couple other options:

Book1
	A	B	C
1	Name	Number	Letter
2	Apr	1	A
3	Apr	1	A
4	Apr	1	A
5	Aug	2	B
6	Aug	2	B
7	Aug	2	B
8	Aug	2	B
9	Aug	2	B
10	Dec	3	C
11	Dec	3	C
12	Feb	4	D
13	Feb	4	D
14	Feb	4	D
15	Feb	4	D
16	Jan	5	E
17	Jan	5	E
18	Jan	5	E
Sheet2

Cell Formulas
Range	Formula
B2:B18	B2	=N(B1)+(A2<>A1)
C2:C18	C2	=SUBSTITUTE(ADDRESS(1,SUMPRODUCT(--($A$1:$A1<>$A$2:$A2)),4),1,"")

 

[FryGirl]

Thank you for the help. Both of these solutions work great.

 

[Eric W]

Glad we could help!