Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Gary''s Student wrote:
1. pick an un-used column and enter: =ROW() and copy down 2. copy the column and paste/special/values back onto the column 3. sort the worksheet by the new column DESCENDING this will reverse all the rows. I thought about that also but wouldn't that put the date field BELOW the data instead above it. Of course I'm assuming the following layout based on the OP's description. You know what they say about assuming:-) 1 12/12/09 2 data1 3 data2 4 12/13/09 5 data3 6 data4 sorts to 6 data4 5 data3 4 12/13/09 3 data1 2 data2 1 12/21/09 gls858 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reversing the order of data separated by commas within a cell? | Excel Discussion (Misc queries) | |||
Reversing Data | Excel Discussion (Misc queries) | |||
Pivot Table is reversing data | Excel Discussion (Misc queries) | |||
Reverse a spreadsheet reversing columns and rows? | Excel Worksheet Functions | |||
Reversing First & Last Name | Excel Worksheet Functions |