Alphabetica Order

[limo2088]

Any idea why this is not in alpabethical order and why when i try to drag C18 up to C7 it doesnt work?

Alpha2.xlsx
	A	B	C
7
8
9	Morning Line-Up & Stop Count
10	Joseph Micco
11	Jonathon Honaker
12	Jakob Lenos
13	Quinton Clemons
14	Lee Donnelly
15	Cassidy Kaurich
16	Johnathan McRae
17	Colton Starcher		Cassidy Kaurich
18	Derrick Marshall		Asia Dickey
19	Alexis Torres		Alexis Torres
20	Regis Wilkins		Asia Dickey
21	Dylan Stewart		Cassidy Kaurich
22	Asia Dickey		Colton Starcher
23	Ronald Knight		Derrick Marshall
24	Donald McGhee jr		Donald McGhee jr
25	Lawrence Lambert		Dylan Stewart
26	Jayda Nix		Felix Muniz Ramos
27	Shon Byars		Jakob Lenos
28	Travis Snider		Jayda Nix
29	Felix Muniz Ramos		Johnathan McRae
30	Luis Torres		Jonathon Honaker
31	LaShae Johnson		Joseph Micco
32	0		LaShae Johnson
33	0		Lawrence Lambert
34	0		Lee Donnelly
35	0		Luis Torres
36	0		Quinton Clemons
37			Regis Wilkins
38			Ronald Knight
39			Shon Byars
Sheet2

Cell Formulas
Range	Formula
C14:C16	C14	=IFERROR(INDEX($A$10:$A$45,AGGREGATE(15,6,(ROW($A$10:$A$45)-ROW($A$10)+1)/(COUNTIFS($A$10:$A$45,"<"&$A$10:$A$45)+1=ROWS(#REF!))/($A$10:$A$45<>""),1)),"")
C17:C18	C17	=IFERROR(INDEX($A$10:$A$45,AGGREGATE(15,6,(ROW($A$10:$A$45)-ROW($A$10)+1)/(COUNTIFS($A$10:$A$45,"<"&$A$10:$A$45)+1=ROWS(C1:C$3))/($A$10:$A$45<>""),1)),"")
C19:C39	C19	=IFERROR(INDEX($A$10:$A$45,AGGREGATE(15,6,(ROW($A$10:$A$45)-ROW($A$10)+1)/(COUNTIFS($A$10:$A$45,"<"&$A$10:$A$45)+1=ROWS(C$3:C3))/($A$10:$A$45<>""),1)),"")

 

[RoryA]

The formula in the first output cell should be:

=IFERROR(INDEX($A$10:$A$45,AGGREGATE(15,6,(ROW($A$10:$A$45)-ROW($A$10)+1)/(COUNTIFS($A$10:$A$45,"<"&$A$10:$A$45)+1=ROWS(C$1:C1))/($A$10:$A$45<>""),1)),"")

then copy down.

 

[limo2088]

The formula in the first output cell should be:

=IFERROR(INDEX($A$10:$A$45,AGGREGATE(15,6,(ROW($A$10:$A$45)-ROW($A$10)+1)/(COUNTIFS($A$10:$A$45,"<"&$A$10:$A$45)+1=ROWS(C$1:C1))/($A$10:$A$45<>""),1)),"")

then copy down.

Thank you soooo much!