switching order of numbers

[oinkboink]

Hi all. I need help with some data. I have a series of numbers that are listed vertically:

1
2
3
4
5

I need to select them all and switch their orders like this:

5
4
3
2
1

Can someone tell me how to do this? Thanks very much.

[VBA Noob]

Select a cell within the range then > Data > Sort > Descending

VBA Noob

[oinkboink]

hello, thank you for the reply. I cannot find "descending". When you say select a cell, you mean just click one cell? dont select the whole range? Additionally I just want you to know i am using excel 2007, if that makes a difference. And i guess the other thing i have to mention is the example of mine was perhaps bad.

Heres a better example of numbers im dealing with and how they appear:

5
1
6
8
2
9

So id need them to appear like

9
2
8
6
1
5

These are stock prices so they are in no numerical order. So i assume even if i could find descending that this would put them in descending numerical value?

Any help appreciated, sorry if i wasnt clear. thx

[Paul]

A reasonably simple method would be to use an array formula. For example, if your data was in cells A1:A100, then in B1 use:

=OFFSET($A$1:$A$100,MAX(ROW($B$1:$B$100))-ROW(),0)

** After typing this formula, you must press CONTROL+SHIFT+ENTER since it is an array formula. (By doing so, braces will automatically be added around the formula. Don't add the braces, {}, yourself.)

After pressing C+S+E, you should now see the value from the last row in column A appear in B1. Fill the formula in B1 down to B100 and you'll now have a reversed list.

[VBA Noob]

See link under "Reversing The Order Of A List"


http://www.cpearson.com/excel/lists.htm

or

=INDEX($A$1:$A$6,ROWS($A$1:$A$6)-(ROW()-ROW(B$1)))

VBA Noob