Sorting columns help

[IrisDiane]

Hello! I need some help with Excel. In the sheet "AL GS" I need table column "E" to be sorted by letter. (All the "H's" at the top then "F" then "I" but due to the formulas in columns A-E I cannot find a way to do this.
(I also cannot reorganize the data on sheet "Blue"

Any help would be appreciated!

Helper(1463).xlsx
	A	B		D	E
1	PIT
2	GO:			MD	All Markets
3	C:
4
5
6
7	Trade Name	U PHI		Additional Comments	Type
8	A	222		ZERO	H
9	B	444		DNA	I
10	D	444		-	F
11	E	222		-	I
12	F	222		-	H
13	G	222		ZERO	I
14	H	222		DNA	F
15	I	222		DNA	F
16	J	222		ZERO	I
17	L	222		ZERO	I
19	T	444		ZERO	F
22	W	444		ZERO	F
23	X	444		ZERO	F
24	DD	222		ZERO	H
25	EE	222		ZERO	F
26	FF	222		ZERO	I
27	JJ	444		ZERO	H
28	MM	444		ZERO	I
30	VV	222		ZERO	H
32	FFF	444		ZERO	F
33	MMM	444		DNA	H
34	RRR	222		DNA	I
35	XXX	444		ZERO	I
37	ZZZ	444		ZERO	I
38
39
40
41
42
43
44	No Substitutions
45
46
47
48
49
50
AL GS

Cell Formulas
Range	Formula
A8:A17,A19,A22:A28,A30,A32:A35,A37:A43	A8	=IFERROR(INDEX('Blue '!C:C,AGGREGATE(15,6,ROW('Blue '!C$5:C$121)/('Blue '!B$5:B$121=E$2),ROWS(B$8:B8))),"")
B8:B17,B19,B22:B28,B30,B32:B35,B37:B43	B8	=IFERROR(INDEX('Blue '!E:E,AGGREGATE(15,6,ROW('Blue '!E$5:E$121)/('Blue '!B$5:B$121=E$2),ROWS(C$8:C8))),"")
D8:D17,D19,D22:D28,D30,D32:D35,D37:D43	D8	=IFERROR(INDEX('Blue '!F:F,AGGREGATE(15,6,ROW('Blue '!F$5:F$121)/('Blue '!B$5:B$121=E$2),ROWS(D$8:D8))),"")
E8:E17,E19,E22:E28,E30,E32:E35,E37:E43	E8	=IFERROR(INDEX('Blue '!G:G,AGGREGATE(15,6,ROW('Blue '!G$5:G$121)/('Blue '!B$5:B$121=E$2),ROWS(E$8:E8))),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B2:C2	List	=#REF!
A6:E6	List	=#REF!

Helper(1463).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1			Blueberry
2
3	EU	AM	TN	C	U	Comments	Type	AI	C2	A	CH	E	J	K	U2	V
4	EU	AM	TN	C	U	Comments	Type	AI	C	A	CH	E	J	K	U	V
5	EU	All Markets	A	111	222	ZERO	H	AMA	1	2	3	4	5	6	7	8
6	EU	All Markets	B	333	444	DNA	I	BMA	1	2	3	4	5	6	7	8
7			C	111	222	-	F	CMA	1	2	3	4	5	6	7	8
8	EU	All Markets	D	333	444	-	F	DMA	1	2	3	4	5	6	7	8
9		All Markets	E	111	222	-	I	EMA	1	2	3	4	5	6	7	8
10		All Markets	F	111	222	-	H	FMA	1	2	3	4	5	6	7	8
11	EU	All Markets	G	111	222	ZERO	I	GMA	1	2	3	4	5	6	7	8
12		All Markets	H	111	222	DNA	F	HMA	1	2	3	4	5	6	7	8
13	EU	All Markets	I	111	222	DNA	F	IMA	1	2	3	4	5	6	7	8
14		All Markets	J	111	222	ZERO	I	JMA	1	2	3	4	5	6	7	8
15	EU		K	111	222	DNA	H	KMA	1	2	3	4	5	6	7	8
16	EU	All Markets	L	111	222	ZERO	I	LMA	1	2	3	4	5	6	7	8
17	EU		M	111	222	ZERO	F	MMA	1	2	3	4	5	6	7	8
18	EU		N	111	222	ZERO	H	NMA	1	2	3	4	5	6	7	8
19	EU		O	111	222	ZERO	H	OMA	1	2	3	4	5	6	7	8
20	EU		P	111	222	ZERO	F	PMA	1	2	3	4	5	6	7	8
21	EU		Q	111	222	ZERO	I	QMA	1	2	3	4	5	6	7	8
22	EU		R	333	444	ZERO	I	RMA	1	2	3	4	5	6	7	8
23		All Markets	S	333	444	ZERO	I	SMA	1	2	3	4	5	6	7	8
24		All Markets	T	333	444	ZERO	F	TMA	1	2	3	4	5	6	7	8
25		All Markets	U	333	444	ZERO	I	UMA	1	2	3	4	5	6	7	8
26		All Markets	V	333	444	ZERO	H	VMA	1	2	3	4	5	6	7	8
27		All Markets	W	333	444	ZERO	F	WMA	1	2	3	4	5	6	7	8
28		All Markets	X	333	444	ZERO	F	XMA	1	2	3	4	5	6	7	8
29			Y	333	444	ZERO	F	YMA	1	2	3	4	5	6	7	8
30	EU		Z	333	444	ZERO	F	ZMA	1	2	3	4	5	6	7	8
31	EU		AA	333	444	ZERO	H	AQW	1	2	3	4	5	6	7	8
32	EU		BB	111	222	ZERO	F	BQW	1	2	3	4	5	6	7	8
33	EU		CC	111	222	ZERO	F	CQW	1	2	3	4	5	6	7	8
34	EU	All Markets	DD	111	222	ZERO	H	DQW	1	2	3	4	5	6	7	8
35	EU	All Markets	EE	111	222	ZERO	F	EQW	1	2	3	4	5	6	7	8
36	EU	All Markets	FF	111	222	ZERO	I	FQW	1	2	3	4	5	6	7	8
37	EU		GG	111	222	ZERO	F	GQW	1	2	3	4	5	6	7	8
38	EU		HH	111	222	ZERO	F	HQW	1	2	3	4	5	6	7	8
39	EU		II	333	444	ZERO	H	IQW	1	2	3	4	5	6	7	8
40		All Markets	JJ	333	444	ZERO	H	JQW	1	2	3	4	5	6	7	8
41			KK	333	444	ZERO	H	KQW	1	2	3	4	5	6	7	8
42			LL	333	444	ZERO	H	LQW	1	2	3	4	5	6	7	8
43		All Markets	MM	333	444	ZERO	I	MQW	1	2	3	4	5	6	7	8
44			NN	333	444	ZERO	H	NQW	1	2	3	4	5	6	7	8
45			OO	333	444	ZERO	F	OQW	1	2	3	4	5	6	7	8
46		All Markets	PP	333	444	ZERO	I	PQW	1	2	3	4	5	6	7	8
47			QQ	333	444	ZERO	I	QQW	1	2	3	4	5	6	7	8
48			RR	111	222	ZERO	H	RQW	1	2	3	4	5	6	7	8
49			SS	111	222	ZERO	F	SQW	1	2	3	4	5	6	7	8
50			TT	111	222	ZERO	F	TQW	1	2	3	4	5	6	7	8
51			UU	111	222	ZERO	I	UQW	1	2	3	4	5	6	7	8
52		All Markets	VV	111	222	ZERO	H	VQW	1	2	3	4	5	6	7	8
53			WW	111	222	ZERO	H	WQW	1	2	3	4	5	6	7	8
54			XX	111	222	ZERO	H	XQW	1	2	3	4	5	6	7	8
55			YY	333	444	ZERO	I	YQW	1	2	3	4	5	6	7	8
56		All Markets	ZZ	333	444	ZERO	H	ZQW	1	2	3	4	5	6	7	8
57			AAA	333	444	ZERO	H	AAS	1	2	3	4	5	6	7	8
58			BBB	333	444	ZERO	F	BAS	1	2	3	4	5	6	7	8
59			CCC	333	444	ZERO	I	CAS	1	2	3	4	5	6	7	8
60			DDD	333	444	ZERO	F	DAS	1	2	3	4	5	6	7	8
61			EEE	333	444	ZERO	F	EAS	1	2	3	4	5	6	7	8
62		All Markets	FFF	333	444	ZERO	F	FAS	1	2	3	4	5	6	7	8
63			GGG	111	222	ZERO	F	GAS	1	2	3	4	5	6	7	8
64			HHH	111	222	DNA	I	HAS	1	2	3	4	5	6	7	8
65			III	111	222	DNA	F	IAS	1	2	3	4	5	6	7	8
66			JJJ	333	444	DNA	I	JAS	1	2	3	4	5	6	7	8
67			KKK	333	444	DNA	F	KAS	1	2	3	4	5	6	7	8
68			LLL	333	444	DNA	F	LAS	1	2	3	4	5	6	7	8
69		All Markets	MMM	333	444	DNA	H	MAS	1	2	3	4	5	6	7	8
70			NNN	333	444	DNA	H	NAS	1	2	3	4	5	6	7	8
71			OOO	333	444	DNA	H	OAS	1	2	3	4	5	6	7	8
72			PPP	333	444	DNA	I	PAS	1	2	3	4	5	6	7	8
73			QQQ	111	222	DNA	I	QAS	1	2	3	4	5	6	7	8
74		All Markets	RRR	111	222	DNA	I	RAS	1	2	3	4	5	6	7	8
75			SSS	111	222	ZERO	I	SAS	1	2	3	4	5	6	7	8
76			TTT	111	222	ZERO	F	TAS	1	2	3	4	5	6	7	8
77	EU		UUU	333	444	ZERO	H	UAS	1	2	3	4	5	6	7	8
78			VVV	333	444	ZERO	I	VAS	1	2	3	4	5	6	7	8
79			WWW	333	444	ZERO	H	WAS	1	2	3	4	5	6	7	8
80		All Markets	XXX	333	444	ZERO	I	XAS	1	2	3	4	5	6	7	8
81		All Markets	YYY	333	444	ZERO	F	YAS	1	2	3	4	5	6	7	8
82		All Markets	ZZZ	333	444	ZERO	I	ZAS	1	2	3	4	5	6	7	8
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
Blue

 

[jasonb75]

Try a helper column in the 'Blue ' sheet.

In Q3 and fill down to the end.

=IF(G3="","",COUNTIF(G$3:G$121,">"&G3")+COUNTIF(G$3:G3,G3))

Then change the formula in E8 of the other sheet to

=IFERROR(INDEX('Blue '!G$3:G$121,MATCH(ROWS(E$8:E8),'Blue '!Q$3:Q$121,0)),"")

Use the same formula in the other columns of the results table, changing the INDEX column as necessary.