I have a worksheet that has multiple columns with dates in random order. I
need to sort the dates by descending order first count them and then group
them by period. For example
Task 1 Task 2 Task 3
1/5/2006 1/11/2006 1/5/2006
1/17/2006 1/12/2006 1/11/2006
1/26/2006 1/16/2006 2/6/2006
2/1/2006 1/16/2006 2/4/2005
2/22/2006 1/16/2006 2/4/2005
3/8/2006 1/16/2006 2/4/2005
3/13/2006 1/16/2006 2/17/2005
3/14/2006 1/18/2006 2/17/2005
3/14/2006 1/22/2006 2/18/2005
3/16/2006 1/22/2006 1/5/2006
3/16/2006 1/31/2006 1/16/2006
3/16/2006 2/6/2006 1/31/2006
3/16/2006 2/6/2006 2/6/2006
3/22/2006 2/6/2006 2/6/2006
3/23/2006 2/6/2006 3/11/2006
3/28/2006 2/6/2006 3/4/2005

I need something that looks like

Jan 1-15 Jan 15-31 Feb 1-15 Feb 15-28 Mar 1-15
Task 1 1 2 1 1 4
Task 2 2 8 5
Task 3 3 6 5 2


Any help on this is appreciated

Hello,

Are you always going to have the same groupings (which appear to be
semi-monthly)? Also, is this something that is year specific or can it cross
years as well? In other words, would you start over every 1/1/YYYY or do you
want to see something like:

Jan 1-15 Jan 15-31 Feb 1-15 Feb 15-28 Mar 1-15........ Jan 1 - 15
> Task 1 1 2 1 1 4 7
> Task 2 2 8 5
> Task 3 3 6 5 2

Thanks,
Roger

"JayMan" wrote:

> I have a worksheet that has multiple columns with dates in random order. I
> need to sort the dates by descending order first count them and then group
> them by period. For example
> Task 1 Task 2 Task 3
> 1/5/2006 1/11/2006 1/5/2006
> 1/17/2006 1/12/2006 1/11/2006
> 1/26/2006 1/16/2006 2/6/2006
> 2/1/2006 1/16/2006 2/4/2005
> 2/22/2006 1/16/2006 2/4/2005
> 3/8/2006 1/16/2006 2/4/2005
> 3/13/2006 1/16/2006 2/17/2005
> 3/14/2006 1/18/2006 2/17/2005
> 3/14/2006 1/22/2006 2/18/2005
> 3/16/2006 1/22/2006 1/5/2006
> 3/16/2006 1/31/2006 1/16/2006
> 3/16/2006 2/6/2006 1/31/2006
> 3/16/2006 2/6/2006 2/6/2006
> 3/22/2006 2/6/2006 2/6/2006
> 3/23/2006 2/6/2006 3/11/2006
> 3/28/2006 2/6/2006 3/4/2005
>
> I need something that looks like
>
> Jan 1-15 Jan 15-31 Feb 1-15 Feb 15-28 Mar 1-15
> Task 1 1 2 1 1 4
> Task 2 2 8 5
> Task 3 3 6 5 2
>
>
> Any help on this is appreciated
>

Roger
the listing can cross years but your output looks good.

"Roger Converse" wrote:

> Hello,
>
> Are you always going to have the same groupings (which appear to be
> semi-monthly)? Also, is this something that is year specific or can it cross
> years as well? In other words, would you start over every 1/1/YYYY or do you
> want to see something like:
>
> Jan 1-15 Jan 15-31 Feb 1-15 Feb 15-28 Mar 1-15........ Jan 1 - 15
> > Task 1 1 2 1 1 4 7
> > Task 2 2 8 5
> > Task 3 3 6 5 2
>
> Thanks,
> Roger
>
> "JayMan" wrote:
>
> > I have a worksheet that has multiple columns with dates in random order. I
> > need to sort the dates by descending order first count them and then group
> > them by period. For example
> > Task 1 Task 2 Task 3
> > 1/5/2006 1/11/2006 1/5/2006
> > 1/17/2006 1/12/2006 1/11/2006
> > 1/26/2006 1/16/2006 2/6/2006
> > 2/1/2006 1/16/2006 2/4/2005
> > 2/22/2006 1/16/2006 2/4/2005
> > 3/8/2006 1/16/2006 2/4/2005
> > 3/13/2006 1/16/2006 2/17/2005
> > 3/14/2006 1/18/2006 2/17/2005
> > 3/14/2006 1/22/2006 2/18/2005
> > 3/16/2006 1/22/2006 1/5/2006
> > 3/16/2006 1/31/2006 1/16/2006
> > 3/16/2006 2/6/2006 1/31/2006
> > 3/16/2006 2/6/2006 2/6/2006
> > 3/22/2006 2/6/2006 2/6/2006
> > 3/23/2006 2/6/2006 3/11/2006
> > 3/28/2006 2/6/2006 3/4/2005
> >
> > I need something that looks like
> >
> > Jan 1-15 Jan 15-31 Feb 1-15 Feb 15-28 Mar 1-15
> > Task 1 1 2 1 1 4
> > Task 2 2 8 5
> > Task 3 3 6 5 2
> >
> >
> > Any help on this is appreciated
> >