Sort 4 columns using excel 2000

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
1,827
Hello,

Data are found in the Range A5:P22 I want to Sort 4 columns D, E, F and G data and full range accordingly in the ascending order

I tried to sort as shown below but it sort only 3 columns so far 4th column data remain in the descending order. Like G6 remains 21 & G7 remains 15...G15=42, G16=24, G17=33

*ABCDEFGHIJKLMNOPQ
1
2
3
4
5YearSORTEOFECHAn1n2n3n4n5*1*2EMSum Numn2-n1n3-n2n4-n3n5-n4
6200414
14/05/2004​
1321323926
96​
218117
7200444
10/12/2004​
1313164327
76​
210327
8200639
29/09/2006​
136182458
52​
23126
9200734
24/08/2007​
1316424823
110​
213266
10200852
26/12/2008​
1226445017
123​
124186
1120127
24/01/2012​
1262036811
65​
141416
12201255
10/07/2012​
1316243718
81​
213813
13201398
06/12/2013​
12183136710
88​
116135
1420144
10/01/2014​
12112729110
70​
19162
15201499
09/12/2014​
13314246411
123​
228114
1620163
12/01/2016​
1210304418
87​
182014
17201874
14/09/2018​
1333404534
122​
23075
18201884
19/10/2018​
13294748312
128​
226181
19201885
23/10/2018​
1252132212
61​
131611
20201953
28/06/2019​
13163349211
102​
2131716
21201999
06/12/2019​
13273946110
116​
224127
22202062
04/08/2020​
125154258
65​
131027
23
24
*ABCDEFGHIJKLMNOPQ
1
2
3
4
5YearSORTEOFECHAn1n2n3n4n5*1*2EMSum Numn2-n1n3-n2n4-n3n5-n4
6201885
23/10/2018​
1252132212
61​
131611
7202062
04/08/2020​
125154258
65​
131027
820127
24/01/2012​
1262036811
65​
141416
920163
12/01/2016​
1210304418
87​
182014
1020144
10/01/2014​
12112729110
70​
19162
11201398
06/12/2013​
12183136710
88​
116135
12200852
26/12/2008​
1226445017
123​
124186
13200639
29/09/2006​
136182458
52​
23126
14200444
10/12/2004​
1313164327
76​
210327
15200734
24/08/2007​
1316424823
110​
213266
16201255
10/07/2012​
1316243718
81​
213813
17201953
28/06/2019​
13163349211
102​
2131716
18200414
14/05/2004​
1321323926
96​
218117
19201999
06/12/2019​
13273946110
116​
224127
20201884
19/10/2018​
13294748312
128​
226181
21201499
09/12/2014​
13314246411
123​
228114
22201874
14/09/2018​
1333404534
122​
23075
23
24

Please need help

Simple image is attached

Thank you all.

I am using Excel 2000

Regards,
Moti
 

Attachments

  • Sort 4 Columns.png
    Sort 4 Columns.png
    86.7 KB · Views: 3

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,624
Office Version
  1. 365
Platform
  1. Windows
All you need to do is sort the data by one column (the lowest priority) then sort again by the other 3 columns.
 
Solution

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
1,827
All you need to do is sort the data by one column (the lowest priority) then sort again by the other 3 columns.
Fluff, thank you for the tip I have spent 20-hours instead of sorting column D, E and F now sort as per your suggestion E, F and G and it worked fine.

Thank you so much for you help.

Kind Regards
Moti :)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,624
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
1,827

ADVERTISEMENT

Hello again,

I am blocked can not able to sort following all 5 columns, as it should be if I sort C, D and E I am getting result as per attached image but column F remain unsorted where 36 has to be upside and 45 down to 36, does it has any solution for my older version it could be VBA also is perfect.

ABCDEFGH
720263247
720384043
721222428
721232444
721233638
721263543
721264345
723243436
723293741
723303245
723303236
723313339
724263745
725274849
725303239
725344049
726363843
727293950
727304043


Regards,
Moti
 

Attachments

  • Sort All.png
    Sort All.png
    15 KB · Views: 1

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,624
Office Version
  1. 365
Platform
  1. Windows
Sort on cols E & F, then sort on cols B, C & D
 

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
1,827

ADVERTISEMENT

Sort on cols E & F, then sort on cols B, C & D
Yes master Fluff, following as per your suggested step it sorted as I request thank you so much for your kind help and time.

It is just a question does there is any unique solution to sort all 5 at a time in one step only because I am facing this problem in different situations.

Kind Regards
Moti :)
 

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
1,827
Not with your version of Excel.
Fluff, I can understand, normally said *Old Is Gold* but here it has meaning Old is Old* thank you master for your answer.

Have a great weekend 🥂

Kind Regards
Moti :)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,624
Office Version
  1. 365
Platform
  1. Windows
Glad to help & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,725
Messages
5,626,515
Members
416,187
Latest member
L_D18

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