Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Ok so I want to reverse the worksheet in the exact order that it's already
in. Meaning I want the bottom row to become the top row and then the 2nd to bottom row to become the 2nd row from the top. The first row is in date form but for some reason it won't sort like that, it gets all mixed up. There are 9 rows labeled: Date, Type, To/From, Name/Email, Status, Gross, Fee, Net Amount, Balance April 30, 2006, Payment, From, Cust. John Smith, Completed, $460.00 USD, -$13.64 USD, $446.36 USD, $1,197.24 USD it keeps going all the way to April 1, 2006 as the last row. So how do I just flip this so April 1, 2006 is at the top and April 30, 2006 is at the bottom? I hope this makes sense. :) |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Easy. Highlight all of the information (incl the headings) and sort the Date
column in Ascending order (Data, Sort, Sort By [Date]). "bnuphar" wrote: Ok so I want to reverse the worksheet in the exact order that it's already in. Meaning I want the bottom row to become the top row and then the 2nd to bottom row to become the 2nd row from the top. The first row is in date form but for some reason it won't sort like that, it gets all mixed up. There are 9 rows labeled: Date, Type, To/From, Name/Email, Status, Gross, Fee, Net Amount, Balance April 30, 2006, Payment, From, Cust. John Smith, Completed, $460.00 USD, -$13.64 USD, $446.36 USD, $1,197.24 USD it keeps going all the way to April 1, 2006 as the last row. So how do I just flip this so April 1, 2006 is at the top and April 30, 2006 is at the bottom? I hope this makes sense. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
reverse value | Excel Worksheet Functions | |||
reverse value | Excel Worksheet Functions | |||
Reverse worksheet data by columns | Excel Worksheet Functions | |||
Reverse Sum | Excel Discussion (Misc queries) | |||
Reverse Worksheet | Excel Discussion (Misc queries) |