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

[shabz]

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?

 

[Eduardo]

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

 

[Bob Umlas]

Sort descending by date...?

 

[RagDyer]

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))

 

[shabz]

how do i enter this formula?

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))

 

[Bob Umlas]

Nice trick! I like it!
Bob Umlas
Excel MVP

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))

 

[Shane Devenshire]

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)

 

[RagDyeR]

Appreciate your comment.