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!

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!

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!

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!