Sort Order - Non contiguous
 

Hi,
How do I reverse the order in a column.

My Column at the momoment is

a
c
d
r
b
t
c
x

and I want to arrange it staring form bottom to top
x
c
t
b
r
d
c
a

and can this be done for any charachter i.e Column of text as above and
column of numbers and a combination.
Thanks

Sort Order - Non contiguous
 

Same question asked in public.excel newsgroup


"Yunus" wrote in message
m...


Hi,
How do I reverse the order in a column.

My Column at the momoment is

a
c
d
r
b
t
c
x

and I want to arrange it staring form bottom to top
x
c
t
b
r
d
c
a

and can this be done for any charachter i.e Column of text as above and
column of numbers and a combination.
Thanks

Sort Order - Non contiguous
 

Entered in B1 assuming data is in column A

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

Drag/copy down to B8



Gord


On Sat, 10 Mar 2012 10:04:12 -0000, Yunus
wrote:



Hi,
How do I reverse the order in a column.

My Column at the momoment is

a
c
d
r
b
t
c
x

and I want to arrange it staring form bottom to top
x
c
t
b
r
d
c
a

and can this be done for any charachter i.e Column of text as above and
column of numbers and a combination.
Thanks