A | 10 |
B | 5 |
C | 20 |
D | 1 |
E | 13 |
F | 15 |
G | 18 |
H | 2 |
I | 6 |
J | 7 |
<tbody>
</tbody>
Using the above table column A is an array Function that pulls data from another sheet which will Every time I sort Column B to Sort A to Z it always goes back to the normal Sort. I want column C to pull the data form Column A and List them based on the order of the number to the right so. So Results for Column C Should be as Follows:
D |
H |
B |
I |
J |
A |
E |
F |
G |
C |
<tbody>
</tbody>
Last edited: