how do u reorder data in a column so last cell entry is first?
Appreciate your comment.
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
"Bob Umlas" wrote in message
...
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?
|