Sort specific data in order

[JTL9161]

I have this table below. I am trying to sort all the A's and B's separately in order of lowest to highest. Meaning I need all the A's sorted from lowest to highest and then the B's sorted lowest to highest. The numbers in the column with the "1" will change from week to week so I need the sort to change accordingly. The 1st name for the A's would be Tim with 4.0 and the 1st name for the B's would be Mike with 4.0. As i said the numbers in the "1" column will change from week to week so I need the sort to change accordingly. I can sort these where they are or make another table next to it to show the sorted names and numbers.

Thank you for you help,
James

		1
A	Tom	5.0
A	Bob	8.0
B	Phil	5.0
B	Dave	7.0
B	Greg	5.0
B	Brian	7.0
A	Tim	4.0
B	Rick	6.0
A	Vin	5.0
B	Jim	5.0
B	Mike	4.0
B	Peter	7.0
A	John	5.0
B	Ray	6.0
A	Lee	5.0
A	Charles	5.0
B	Fred	6.0
A	Steve	6.0
A	Keith	5.0
A	Ryan	5.0

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1				1
2	A	Tom		5		A	Tim	4
3	A	Bob		8		A	Tom	5
4	B	Phil		5		A	Vin	5
5	B	Dave		7		A	John	5
6	B	Greg		5		A	Lee	5
7	B	Brian		7		A	Charles	5
8	A	Tim		4		A	Keith	5
9	B	Rick		6		A	Ryan	5
10	A	Vin		5		A	Steve	6
11	B	Jim		5		A	Bob	8
12	B	Mike		4		B	Mike	4
13	B	Peter		7		B	Phil	5
14	A	John		5		B	Greg	5
15	B	Ray		6		B	Jim	5
16	A	Lee		5		B	Rick	6
17	A	Charles		5		B	Ray	6
18	B	Fred		6		B	Fred	6
19	A	Steve		6		B	Dave	7
20	A	Keith		5		B	Brian	7
21	A	Ryan		5		B	Peter	7
Data

Cell Formulas
Range	Formula
F2:H21	F2	=SORT(CHOOSECOLS(A2:D21,1,2,-1),{1,3})
Dynamic array formulas.

 

[JTL9161]

Thanks. I'll give it a try

 

[JTL9161]

Thanks. I'll give it a try

Works great! One tweak, if possible, In the above table, you used columns A, B and the data in column D. How can I do another sort in column "I" using column A, B and data in column E, while my previous sort is still there in column D. Basically, still use the data in columns A and B but now use the data in column E.

Thank you

 

[Fluff]

Just change the range to A2:E21