Sort specific data in order

JTL9161

Well-known Member
Joined
Aug 29, 2012
Messages
599
Office Version
  1. 365
Platform
  1. Windows
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
ATom5.0
ABob8.0
BPhil5.0
BDave7.0
BGreg5.0
BBrian7.0
ATim4.0
BRick6.0
AVin5.0
BJim5.0
BMike4.0
BPeter7.0
AJohn5.0
BRay6.0
ALee5.0
ACharles5.0
BFred6.0
ASteve6.0
AKeith5.0
ARyan5.0
 
How about
Fluff.xlsm
ABCDEFGH
11
2ATom5ATim4
3ABob8ATom5
4BPhil5AVin5
5BDave7AJohn5
6BGreg5ALee5
7BBrian7ACharles5
8ATim4AKeith5
9BRick6ARyan5
10AVin5ASteve6
11BJim5ABob8
12BMike4BMike4
13BPeter7BPhil5
14AJohn5BGreg5
15BRay6BJim5
16ALee5BRick6
17ACharles5BRay6
18BFred6BFred6
19ASteve6BDave7
20AKeith5BBrian7
21ARyan5BPeter7
Data
Cell Formulas
RangeFormula
F2:H21F2=SORT(CHOOSECOLS(A2:D21,1,2,-1),{1,3})
Dynamic array formulas.
 
Upvote 0
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
 
Upvote 0

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
Back
Top