billandrew
Well-known Member
- Joined
- Mar 9, 2014
- Messages
- 743
Afternoon
Is there a way to filter (smallest to largest) East Region in column D "Sales" without the rows below altered. The Entire row of the East region will be moved accordingly.
<tbody>
</tbody>
After
<tbody>
</tbody>
Is there a way to filter (smallest to largest) East Region in column D "Sales" without the rows below altered. The Entire row of the East region will be moved accordingly.
ID | Region | Code | Sales |
101 | East | w | 300 |
102 | West | s | 200 |
103 | North | d | 100 |
104 | South | w | 200 |
105 | East | s | 250 |
106 | West | d | 200 |
107 | North | w | 150 |
108 | South | s | 230 |
109 | East | d | 245 |
110 | West | d | 225 |
111 | North | w | 125 |
112 | South | d | 180 |
<tbody>
</tbody>
After
ID | Region | Code | Sales |
109 | East | d | 245 |
102 | West | s | 200 |
103 | North | d | 100 |
104 | South | w | 200 |
105 | East | s | 250 |
106 | West | d | 200 |
107 | North | w | 150 |
108 | South | s | 230 |
101 | East | w | 300 |
110 | West | d | 225 |
111 | North | w | 125 |
112 | South | d | 180 |
<tbody>
</tbody>
Last edited: