J
JayMan
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
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