Sorting columns help

IrisDiane

New Member
Joined
Dec 11, 2020
Messages
8
Office Version
  1. 2013
Platform
  1. Windows
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
ABDE
1PIT
2GO:MDAll Markets
3C:
4
5
6
7Trade NameU PHIAdditional CommentsType
8A222ZEROH
9B444DNAI
10D444 -F
11E222 -I
12F222 -H
13G222ZEROI
14H222DNAF
15I222DNAF
16J222ZEROI
17L222ZEROI
19T444ZEROF
22W444ZEROF
23X444ZEROF
24DD222ZEROH
25EE222ZEROF
26FF222ZEROI
27JJ444ZEROH
28MM444ZEROI
30VV222ZEROH
32FFF444ZEROF
33MMM444DNAH
34RRR222DNAI
35XXX444ZEROI
37ZZZ444ZEROI
38    
39    
40    
41    
42    
43    
44No Substitutions
45
46
47
48
49
50
AL GS
Cell Formulas
RangeFormula
A8:A17,A19,A22:A28,A30,A32:A35,A37:A43A8=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:B43B8=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:D43D8=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:E43E8=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
CellAllowCriteria
B2:C2List=#REF!
A6:E6List=#REF!



Helper(1463).xlsx
ABCDEFGHIJKLMNOP
1Blueberry
2
3EUAMTNCUCommentsTypeAIC2ACHEJKU2V
4EUAMTNCUCommentsTypeAICACHEJKUV
5EUAll MarketsA111222ZEROHAMA12345678
6EUAll MarketsB333444DNAIBMA12345678
7C111222 -FCMA12345678
8EUAll MarketsD333444 -FDMA12345678
9All MarketsE111222 -IEMA12345678
10All MarketsF111222 -HFMA12345678
11EUAll MarketsG111222ZEROIGMA12345678
12All MarketsH111222DNAFHMA 12345678
13EUAll MarketsI111222DNAFIMA12345678
14All MarketsJ111222ZEROIJMA12345678
15EUK111222DNAHKMA12345678
16EUAll MarketsL111222ZEROILMA12345678
17EUM111222ZEROFMMA12345678
18EUN111222ZEROHNMA12345678
19EUO111222ZEROHOMA12345678
20EUP111222ZEROFPMA12345678
21EUQ111222ZEROIQMA12345678
22EUR333444ZEROIRMA12345678
23All MarketsS333444ZEROISMA12345678
24All MarketsT333444ZEROFTMA12345678
25All MarketsU333444ZEROIUMA12345678
26All MarketsV333444ZEROHVMA12345678
27All MarketsW333444ZEROFWMA12345678
28All MarketsX333444ZEROFXMA12345678
29Y333444ZEROFYMA12345678
30EUZ333444ZEROFZMA12345678
31EUAA333444ZEROHAQW12345678
32EUBB111222ZEROFBQW12345678
33EUCC111222ZEROFCQW12345678
34EUAll MarketsDD111222ZEROHDQW12345678
35EUAll MarketsEE111222ZEROFEQW12345678
36EUAll MarketsFF111222ZEROIFQW12345678
37EUGG111222ZEROFGQW12345678
38EUHH111222ZEROFHQW12345678
39EUII333444ZEROHIQW12345678
40All MarketsJJ333444ZEROHJQW12345678
41KK333444ZEROHKQW12345678
42LL333444ZEROHLQW12345678
43All MarketsMM333444ZEROIMQW12345678
44NN333444ZEROHNQW12345678
45OO333444ZEROFOQW12345678
46All MarketsPP333444ZEROIPQW12345678
47QQ333444ZEROIQQW12345678
48RR111222ZEROHRQW12345678
49SS111222ZEROFSQW12345678
50TT111222ZEROFTQW12345678
51UU111222ZEROIUQW12345678
52All MarketsVV111222ZEROHVQW12345678
53WW111222ZEROHWQW12345678
54XX111222ZEROHXQW12345678
55YY333444ZEROIYQW12345678
56All MarketsZZ333444ZEROHZQW12345678
57AAA333444ZEROHAAS12345678
58BBB333444ZEROFBAS12345678
59CCC333444ZEROICAS12345678
60DDD333444ZEROFDAS12345678
61EEE333444ZEROFEAS12345678
62All MarketsFFF333444ZEROFFAS12345678
63GGG111222ZEROFGAS12345678
64HHH111222DNAIHAS12345678
65III111222DNAFIAS12345678
66JJJ333444DNAIJAS12345678
67KKK333444DNAFKAS12345678
68LLL333444DNAFLAS12345678
69All MarketsMMM333444DNAHMAS12345678
70NNN333444DNAHNAS12345678
71OOO333444DNAHOAS12345678
72PPP333444DNAIPAS12345678
73QQQ111222DNAIQAS12345678
74All MarketsRRR111222DNAIRAS12345678
75SSS111222ZEROISAS12345678
76TTT111222ZEROFTAS12345678
77EUUUU333444ZEROHUAS12345678
78VVV333444ZEROIVAS12345678
79WWW333444ZEROHWAS12345678
80All MarketsXXX333444ZEROIXAS12345678
81All MarketsYYY333444ZEROFYAS12345678
82All MarketsZZZ333444ZEROIZAS12345678
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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
12,610
Office Version
  1. 365
Platform
  1. Windows
Try a helper column in the 'Blue ' sheet.

In Q3 and fill down to the end.
Excel Formula:
=IF(G3="","",COUNTIF(G$3:G$121,">"&G3")+COUNTIF(G$3:G3,G3))
Then change the formula in E8 of the other sheet to
Excel Formula:
=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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,493
Messages
5,636,641
Members
416,932
Latest member
mm07

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top