| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I sort a column of random dates into Consecutive dates
I have a long column of random dates that need to be in order from oldest to
newest. How do I accomplish this in excel? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I sort a column of random dates into Consecutive dates
DataSortDescending.
Gord Dibben MS Excel MVP On Mon, 11 Jun 2007 20:54:00 -0700, Rob Gibson <Rob wrote: I have a long column of random dates that need to be in order from oldest to newest. How do I accomplish this in excel? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I sort a column of random dates into Consecutive dates
Assuming these are real dates which are frozen values (and not formulas
containing RAND()), then just sort ascending on the dates col should do it for you. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rob Gibson" wrote: I have a long column of random dates that need to be in order from oldest to newest. How do I accomplish this in excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing consecutive dates | Excel Discussion (Misc queries) | |||
| Determining consecutive dates? | Excel Worksheet Functions | |||
| How do I sort a column of dates by the month? | Excel Discussion (Misc queries) | |||
| Sort a Column of Dates in Pivot Table | Excel Worksheet Functions | |||
| Trying to create repeating dates and then sort column by date | Excel Worksheet Functions | |||
Hybrid Mode
