Insert a blank column next to your column of numbers. Fill it with a series
of numbers - enter a 1 in the cell next to your first number, then highlight
the column down to the point even with the bottom of your list. Choose Edit
| Fill | Series from the menu
Once you have the series, sort the two columns on the series, but in
descending order. Then delete your series column
Voila
"shockwave_dave" wrote:
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
|