number grouping

[drltr6]

I have a list of numbers from smallest to largest. The number list varies from 12 to 32 numbers. I want to assign the letter "A" to the lowest 25% of the numbers, a "B" to the next lowest 25%, a "C" to the next lowest 25%, and a "D" to the top 25%. In other words, I want to break down my list into 4 separate groups no matter how many numbers are in the list.
Any help would be greatly appreciated.

 

[Fluff]

Did you try the solution by lrobbo314 in post#2?

 

[lrobbo314]

I wouldn't imagine you would have xlookup or sequence on a 2011 version. But who knows about macs.

Avoiding those functions, this seems to do what your asking for.

frolf
	A	B	C	D	E	F	G	H	I
1	Players	Hdcp	Tee	A,B,C,D	TEAM			Letter	Count
2	zBlind Draw	X	g	D				A	7
3	zBlind Draw	X	g	D				B	7
4	Martin, Steve - 37	0	G	A				C	7
5	DiLaura, Tom - 13	4	W	A				D	7
6	Lancaster, Don - 171	4	G	A
7	Wayt, Tim - 403	4	G	A
8	Baun, Dan - 179	5	W	A
9	Randall, Chuck - 313	5	G	A
10	Wallner, Dave - 304	5	G	A
11	McDuff, Mark - 851	7	G	B
12	Lopez, Tony - 362	8	G	B
13	Wilson, Larry - 900	8	G	B
14	Lussier, Denis - 185	8	W	B
15	Geyer, Rolly - 145	9	W	B
16	Plummer, Bob - 126	9	G	B
17	Pfeiller, Bill -1113	10	G	B
18	Hourigan, Bob - 32	11	W	C
19	Krumrie, Harry - 189	11	W	C
20	Thurman, Mike - 76	11	W	C
21	Fleischmann, Jacques - 1229	13	W	C
22	Schoendorf, Tom - 298	13	W	C
23	Goldade, Ron - 91	14	G	C
24	Schrauben, Fred - 6251	14	W	C
25	Connors, Don - 152	15	W	D
26	Feliks, Don - 388	16	B	D
27	Williams, Tom - 81	17	B	D
28	Mizell, Leslie - 499	17	W	D
29	Dupuis, Bob - 236	18	G	D
Sheet1

Cell Formulas
Range	Formula
I2:I5	I2	=COUNTIF($D$2:$D$29,H2)
D2:D29	D2	=LOOKUP(IF(B2="X",MAX($B$2:$B$29)+1,B2),QUARTILE.INC(IF($B$2:$B$29="X",MAX($B$2:$B$29)+1,$B$2:$B$29),{0,1,2,3}),{"A","B","C","D"})

 

[drltr6]

=LOOKUP(IF(B2="X",MAX($B$2:$B$29)+1,B2),QUARTILE.INC(IF($B$2:$B$29="X",MAX($B$2:$B$29)+1,$B$2:$B$29),{0,1,2,3}),{"A","B","C","D"})

Thank you so much!!