One way is to use a helper column next to your data and enter 1 at the top
and fill down holding the CTRL key down until you reach the bottom of your
data. Then sort both columns using the 1 thru N column as the sort column.
HTH
Regards,
Howard
"shockwave_dave" wrote in message
...
I've a long column of numbers in excel which i need to flip round or
invert
but dont know how. I cant use the sort function as it only sorts it in
ascending or descending order but i want to reverse the order of the
numbers
so that bottom becomes top and top becomes bottom for example. Thanks
|