Flipping order of data in a column

[spectracide]

I need to flip the order of data in a column.

For example:

Is: 22
10
23

Need: 23
10
22


How can I do this? I need only flip the data in a column, these cell
are not a part of rows of data thus no ther data must flip with thes
numbers. Obviously the data I am changing is more than 3 cells long
(-

 

[Frank Kabel]

Hi
one way (using a helper column - if this is a one-time operation). If
your data is in column A enter the following:
B1: 1
B2: 2
- select B1:B2 and drag the selection down. This will populate column B
with ascending numbers
- Sort column A+B with column B in descending order
- delete column B

 

[JMay]

Sample to provide understanding:
In cell B6 =OFFSET($A$6,COUNT(A6:$A$14)-1,0) And Copy Down to B14
Where in CellRange A6:A14 you have some numbers, 123,234,345...
Try it and post back if you still have problems..
HTH