heres the question
lets say you have a whole bunch of rows of data, the first colunm being the index (1,2,3 ect) and the next colunm being some numbers
is there a way to sort by the second colunm, and then say, how far down is index 2 from the top?
here an example
1 - 543
2 - 324
3 - 432
4 - 123
5 - 690
now we sort by column 2
5 - 690
1 - 543
3 - 432
2 - 324
4 - 123
is there a way to find the new position (example: index 2 is now #4)
lets say you have a whole bunch of rows of data, the first colunm being the index (1,2,3 ect) and the next colunm being some numbers
is there a way to sort by the second colunm, and then say, how far down is index 2 from the top?
here an example
1 - 543
2 - 324
3 - 432
4 - 123
5 - 690
now we sort by column 2
5 - 690
1 - 543
3 - 432
2 - 324
4 - 123
is there a way to find the new position (example: index 2 is now #4)