Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to reorder data points on a graph? | Charts and Charting in Excel | |||
Control Data Entry - push entry to next cell | Excel Discussion (Misc queries) | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
reorder data | Excel Worksheet Functions | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions |