Quote:
Originally Posted by trvlnmny
I have a file where each row contains data about a geographic
location. The order they are in is south to north. I now have a need
to reverse the order. That is have them now list north to south.
Thanks for your help.
|
Assuming you have the data in Column A (south to north).
try this
In cell B1 enter 1
In cell B2 enter 2
Select B1:B2
Move cursor to Bottom right of range
you should get a + sign
Double click this cell handle
You should get a seq of numbers all the way
down as far as you data in column A.
Now select A1:B1
use ALT + D + S (data sort)
use descending order based on Column B
all the best