# Sort assistance

#### rf78801

##### New Member
Basic sort but I can't figure it out.

Four columns, multiple rows of data. First column is ORDER. 2nd col is HIGH. 3rd col is MED. 4th col is LOW. There is an ORDER entry (numeric) in every row followed by character string data in HIGH/MED/LOW (but only one of the three).

After the sort macro executes I would like the top rows to be any HIGH data entries sorted by ORDER, then MED sorted by ORDER, then LOW sorted by ORDER. All this independent of the alphanumeric content in columns 2-4. Right now it's sorting columns 2-4 alphabetically and jumbling column 1.

Thanks for any assistance!

R

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### Eric W

##### MrExcel MVP
Welcome to MrExcel.

You could do this with a helper column. Try:

Book1
ABCDE
1OrderHighMidLowHelp
26One1
33Two2
44Three3
588Five1
61Six2
721Seven3
833Eight2
97Nine3
1077Ten1
1111Eleven2
122Twelve3
13
Sheet2
Cell Formulas
RangeFormula
E2:E12E2=IF(B2<>"",1,IF(C2<>"",2,3))

Then custom sort it by Help, then Order, and you get:

Book1
ABCDE
1OrderHighMidLowHelp
26One1
377Ten1
488Five1
51Six2
63Two2
711Eleven2
833Eight2
92Twelve3
104Three3
117Nine3
1221Seven3
13
Sheet2

#### Peter_SSs

##### MrExcel MVP, Moderator
Welcome to the MrExcel board!

Following Eric's idea, you could try this and only need to sort on the Help column (small to large)

20 07 27.xlsm
ABCDE
1OrderHighMidLowHelp
26One0.8333
33Two1.6667
44Three2.75
588Five0.9886
61Six1
721Seven2.9524
833Eight1.9697
97Nine2.8571
1077Ten0.987
1111Eleven1.9091
122Twelve2.5
Sort
Cell Formulas
RangeFormula
E2:E12E2=MATCH("?*",B2:D2,0)-1/A2

20 07 27.xlsm
ABCDE
1OrderHighMidLowHelp
26One0.8333
377Ten0.987
488Five0.9886
51Six1
63Two1.6667
711Eleven1.9091
833Eight1.9697
92Twelve2.5
104Three2.75
117Nine2.8571
1221Seven2.9524
Sort
Cell Formulas
RangeFormula
E2:E12E2=MATCH("?*",B2:D2,0)-1/A2

Perfect! Thanks!

Replies
5
Views
321
Replies
1
Views
160
Replies
2
Views
632
Replies
1
Views
157
Replies
3
Views
157

1,181,598
Messages
5,930,800
Members
436,761
Latest member
mintwaxed

### 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.

### Which adblocker are you using?

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

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