Flipping order of data in a column

S

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
(-
 
F

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
 
J

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
 
Top