Sort assistance

[rf78801]

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

 

[Eric W]

Welcome to MrExcel.

You could do this with a helper column. Try:

Book1
	A	B	C	D	E
1	Order	High	Mid	Low	Help
2	6	One			1
3	3		Two		2
4	4			Three	3
5	88	Five			1
6	1		Six		2
7	21			Seven	3
8	33		Eight		2
9	7			Nine	3
10	77	Ten			1
11	11		Eleven		2
12	2			Twelve	3
13
Sheet2

Cell Formulas
Range	Formula
E2:E12	E2	=IF(B2<>"",1,IF(C2<>"",2,3))

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

Book1
	A	B	C	D	E
1	Order	High	Mid	Low	Help
2	6	One			1
3	77	Ten			1
4	88	Five			1
5	1		Six		2
6	3		Two		2
7	11		Eleven		2
8	33		Eight		2
9	2			Twelve	3
10	4			Three	3
11	7			Nine	3
12	21			Seven	3
13
Sheet2

 

[Peter_SSs]

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
	A	B	C	D	E
1	Order	High	Mid	Low	Help
2	6	One			0.8333
3	3		Two		1.6667
4	4			Three	2.75
5	88	Five			0.9886
6	1		Six		1
7	21			Seven	2.9524
8	33		Eight		1.9697
9	7			Nine	2.8571
10	77	Ten			0.987
11	11		Eleven		1.9091
12	2			Twelve	2.5
Sort

Cell Formulas
Range	Formula
E2:E12	E2	=MATCH("?*",B2:D2,0)-1/A2

20 07 27.xlsm
	A	B	C	D	E
1	Order	High	Mid	Low	Help
2	6	One			0.8333
3	77	Ten			0.987
4	88	Five			0.9886
5	1		Six		1
6	3		Two		1.6667
7	11		Eleven		1.9091
8	33		Eight		1.9697
9	2			Twelve	2.5
10	4			Three	2.75
11	7			Nine	2.8571
12	21			Seven	2.9524
Sort

Cell Formulas
Range	Formula
E2:E12	E2	=MATCH("?*",B2:D2,0)-1/A2

 

[rf78801]

Perfect! Thanks!

 

[Peter_SSs]

Perfect! Thanks!

Cheers. Glad we could help.