JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,482
- Office Version
- 365
- Platform
- Windows
The columns below represent two sets of data. Columns C-E is one set and columns F-H is the other.
Is there a way that I can sort rows 5-17 in columns F-H so that the data in column F matches that in column C? That is, can I sort columns F-H so that the Teams are in the same order as they are in column C?
<tbody>
</tbody>
Thanks
Is there a way that I can sort rows 5-17 in columns F-H so that the data in column F matches that in column C? That is, can I sort columns F-H so that the Teams are in the same order as they are in column C?
C/R | C | D | E | F | G | H |
4 | Team | W-L | BPI | Team | W-L | BPI |
5 | Mil | 50-17 | 39.30% | Mil | 50-17 | 40.00% |
6 | GSW | 45-21 | 17.80% | GSW | 45-20 | 20.20% |
7 | Tor | 48-19 | 14.20% | Tor | 47-19 | 12.10% |
8 | Bos | 41-26 | 7.70% | Bos | 41-26 | 7.60% |
9 | Den | 43-22 | 6.00% | Den | 43-22 | 5.70% |
10 | Hou | 41-25 | 3.80% | Uta | 37-28 | 3.60% |
11 | Uta | 37-28 | 3.70% | Hou | 40-25 | 3.50% |
12 | Okc | 40-26 | 2.30% | Okc | 40-26 | 2.20% |
13 | Phi | 42-25 | 1.80% | Ind | 42-24 | 1.80% |
14 | Por | 40-26 | 1.40% | Por | 40-26 | 1.40% |
15 | Ind | 42-25 | 1.30% | Phi | 41-25 | 1.30% |
16 | SA | 38-29 | 0.40% | SA | 37-29 | 0.30% |
17 | LAC | 38-29 | 0.20% | LAC | 38-29 | 0.20% |
<tbody>
</tbody>
Thanks