how do u reorder data in a column so last cell entry is first?
 

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?

how do u reorder data in a column so last cell entry is first?
 

Hi,
Select the data then sort it in descending order by the column where you
have the dates

If this helps please click yes, thanks

"shabz" wrote:

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?

how do u reorder data in a column so last cell entry is first?
 

Sort descending by date...?

"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?

how do u reorder data in a column so last cell entry is first?
 

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?

how do u reorder data in a column so last cell entry is first?
 

how do i enter this formula?

"RagDyer" wrote:

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?

how do u reorder data in a column so last cell entry is first?
 

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?

how do u reorder data in a column so last cell entry is first?
 

Hi,

1. Just sort the data manually like everyone has been telling you, the only
reason to use a formula is if you didn't want to sort the original data. To
sort data, select all the data you want to sort and then choose Data, Sort,
from the 1st Key dropdown pick the column you are sorting and click the
Decending option.
2. To enter the formula, type it in an empty cell, say B1 and copy it down a
distance equal to the length of your data. (Change the range to reflect the
cells containing your data instead of A1:A20)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"shabz" wrote:

how do i enter this formula?

"RagDyer" wrote:

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?

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?