How to reverse the order of a series of cells.

for example,

A1 = abc
A2 = efc
A3 = b96
A4= 934

to become:

B1=934
B2 =b96
B3 =efc
B4 =abc


The contents of the cells do not have any pattern and I cannot use sort etc.


Thanks

Man

One way would be to use a helper column and put sequential numbers from top
to bottom, then do a reverse sort on THAT column to include your data column.

hth
Vaya con Dios,
Chuck, CABGx3



"Lamb Chop" wrote:

How to reverse the order of a series of cells.

for example,

A1 = abc
A2 = efc
A3 = b96
A4= 934

to become:

B1=934
B2 =b96
B3 =efc
B4 =abc


The contents of the cells do not have any pattern and I cannot use sort etc.


Thanks

Man

In B1 enter this formula and copy down to B4:

=INDEX($A$1:$A$4,4-(ROW(A1)-1))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Lamb Chop" wrote in message
...
How to reverse the order of a series of cells.

for example,

A1 = abc
A2 = efc
A3 = b96
A4= 934

to become:

B1=934
B2 =b96
B3 =efc
B4 =abc


The contents of the cells do not have any pattern and I cannot use sort etc.


Thanks

Man