Nice trick! I like it!
Bob Umlas
Excel MVP

"RagDyer" wrote in message
...
To reverse the order with a formula, leaving the original order alone:

Say data in B1 to B20, enter this formula anywhere, and copy down:

=INDEX($B$1:$B$20,ROWS(1:$20))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"shabz" wrote in message
...
i have data in a column, with data of share prices from 2nd june to 5th
may,
but i want the data to be inverted so stock prices of 5th june appear at
the
top of the column and 2nd june at the bottom. How do i re-order the data
so
it presents itself in the new order?