| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting dates and inserting rows
I need to sort dates in a single column and group them so that different
dates are separated by an inserted row. Is there a way to do this without performing it manually? Any help would be greatly appreciated! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting dates and inserting rows
"Group them" using what criteria?
One day groups? One week groups? One month groups? Gord Dibben MS Excel MVP On Fri, 6 Jun 2008 10:25:00 -0700, Andy wrote: I need to sort dates in a single column and group them so that different dates are separated by an inserted row. Is there a way to do this without performing it manually? Any help would be greatly appreciated! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting dates and inserting rows
One day groups, formatted as mm/dd/yy. The actual sort function, putting them
into chronological order, must be done manually (not very difficult) but inserting rows between these different "day groups" could be automated. Thanks for having me clarify. "Gord Dibben" wrote: "Group them" using what criteria? One day groups? One week groups? One month groups? Gord Dibben MS Excel MVP On Fri, 6 Jun 2008 10:25:00 -0700, Andy wrote: I need to sort dates in a single column and group them so that different dates are separated by an inserted row. Is there a way to do this without performing it manually? Any help would be greatly appreciated! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting dates and inserting rows
Your multi-posting of this question is being addressed at other news group.
Gord On Sat, 7 Jun 2008 00:39:02 -0700, Andy wrote: One day groups, formatted as mm/dd/yy. The actual sort function, putting them into chronological order, must be done manually (not very difficult) but inserting rows between these different "day groups" could be automated. Thanks for having me clarify. "Gord Dibben" wrote: "Group them" using what criteria? One day groups? One week groups? One month groups? Gord Dibben MS Excel MVP On Fri, 6 Jun 2008 10:25:00 -0700, Andy wrote: I need to sort dates in a single column and group them so that different dates are separated by an inserted row. Is there a way to do this without performing it manually? Any help would be greatly appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Sorting and Inserting Rows | Excel Discussion (Misc queries) | |||
| Column Inserting and sorting problem | Excel Discussion (Misc queries) | |||
| Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
| Inserting dates | Excel Discussion (Misc queries) | |||
| Inserting pictures then sorting | Excel Discussion (Misc queries) | |||
Hybrid Mode
