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!

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!