One way is to use a use a helper column,
In column B enter 1 in B2 ,2 in B3 and carry on to the end of your range,
then sort both columns by column B, delete or clear contents of column B
when done
Regards,
Alan
"D" wrote in message
...
I have a long colum on numbers, I would like to put them in reverse order.
i.e. A2 has 101
A3 has 103
A4 has 105
Reversed to:
A2 105
A3 103
A4 101
Etc.
Thanks
Don
|