JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 599
- Office Version
- 365
- Platform
- 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
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 |