PC Review


Reply
Thread Tools Rate Thread

changing direction?

 
 
Myles
Guest
Posts: n/a
 
      30th Mar 2009
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 With Quote
 
 
 
 
T. Valko
Guest
Posts: n/a
 
      30th Mar 2009
Select all 3 columns and sort in ascending order by the column that holds
the numeric values.

--
Biff
Microsoft Excel MVP


"Myles" <(E-Mail Removed)> wrote in message
news:76E3448A-E5EF-4988-A546-(E-Mail Removed)...
> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing worksheet direction =?Utf-8?B?YmVyYmVy?= Microsoft Excel Worksheet Functions 7 25th Jun 2007 06:49 PM
changing space bar direction =?Utf-8?B?bWF4bG9uZw==?= Windows XP General 12 18th Mar 2006 07:45 PM
Changing grouping direction? Zerex71 Microsoft Excel Discussion 2 15th Mar 2006 05:06 PM
Changing direction of a document =?Utf-8?B?SmVubg==?= Microsoft Word Document Management 3 13th Dec 2005 06:47 PM
changing direction of text =?Utf-8?B?RGFycmlhbjEw?= Microsoft Word Document Management 2 25th May 2005 05:45 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:50 AM.