Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing direction?
Okay so i have a spreadsheet that starts in cell 2 and goes to 52. Being
counted 1-50. Now if i wanted to have that reversed to where it would be 50 to 1 is there an easy way to do that? Basically it's not 1-50, i just said that to make it more simple. 115.9 NB 114.7 NB DMS 109.5 NB 109.5 SB 101.4 SB DMS 101.1 NB 100.1 SB 97.8 NB 97.9 SB 97.3 NB 94.4 NB 94.4 SB 93.5 NB 93.5 SB 86.7 NB 86.6 SB 85.0 NB DMS 81.3 NB 82.1 SB 76.3 NB 76.3 SB 73.6 NB DMS 73.6 SB DMS 47.1 NB 47.4 SB 46.1 NB 46.1 SB 44.8 SB DMS 43.2 NB 42.8 SB 40.4 NB DMS 38.5 NB 38.5 SB 35.2 NB 35.2 SB 34.0 NB DMS 34.0 SB DMS 33.1 NB 33.1 SB 28.9 NB 28.6 SB 25.4 NB 25.5 SB 23.5 NB 23.5 SB 21.0 SB DMS 20.2 SB 20.2 NB 18.4 NB 18.7 SB 17.6 NB 17.6 SB 16.5 NB 16.5 SB 13.7 NB 13.8 SB 12.2 NB 12.2 SB 9.0 NB 9.0 SB 7.3 NB DMS 5.9 NB 5.9 SB 5.0 NB 5.0 SB 3.0 NB 3.0 SB 1.3 NB 1.3 SB Is the actual list, but i need it to be going the opposite direction meaning smallest number at top down to largest number. Is there an easy way to do this? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing direction?
Select all 3 columns and sort in ascending order by the column that holds
the numeric values. -- Biff Microsoft Excel MVP "Myles" wrote in message ... Okay so i have a spreadsheet that starts in cell 2 and goes to 52. Being counted 1-50. Now if i wanted to have that reversed to where it would be 50 to 1 is there an easy way to do that? Basically it's not 1-50, i just said that to make it more simple. 115.9 NB 114.7 NB DMS 109.5 NB 109.5 SB 101.4 SB DMS 101.1 NB 100.1 SB 97.8 NB 97.9 SB 97.3 NB 94.4 NB 94.4 SB 93.5 NB 93.5 SB 86.7 NB 86.6 SB 85.0 NB DMS 81.3 NB 82.1 SB 76.3 NB 76.3 SB 73.6 NB DMS 73.6 SB DMS 47.1 NB 47.4 SB 46.1 NB 46.1 SB 44.8 SB DMS 43.2 NB 42.8 SB 40.4 NB DMS 38.5 NB 38.5 SB 35.2 NB 35.2 SB 34.0 NB DMS 34.0 SB DMS 33.1 NB 33.1 SB 28.9 NB 28.6 SB 25.4 NB 25.5 SB 23.5 NB 23.5 SB 21.0 SB DMS 20.2 SB 20.2 NB 18.4 NB 18.7 SB 17.6 NB 17.6 SB 16.5 NB 16.5 SB 13.7 NB 13.8 SB 12.2 NB 12.2 SB 9.0 NB 9.0 SB 7.3 NB DMS 5.9 NB 5.9 SB 5.0 NB 5.0 SB 3.0 NB 3.0 SB 1.3 NB 1.3 SB Is the actual list, but i need it to be going the opposite direction meaning smallest number at top down to largest number. Is there an easy way to do this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Direction Columns/Rows | Excel Discussion (Misc queries) | |||
Need Direction | New Users to Excel | |||
Changing worksheet direction | Excel Worksheet Functions | |||
I need direction | Excel Discussion (Misc queries) | |||
Changing the Direction of Data within a Column | Excel Worksheet Functions |