I know how to do a SUMIF and I know that text can be concatonated but...
I want to concatonate/group some text depending on some date values, grouping them into date ranges of a week.
e.g.
1/1/07 SD
1/1/07 GH
3/1/07 FD
8/1/07 WE
1/2/07 JU
would become (Dates in this instance are week commencing values)
1/1/07 SD, GH, FD
8/1/07 WE
15/1/07
22/1/07
29/1/07 JU
5/2/07
12/2/07
Any pointers would be greatly appreciated
I want to concatonate/group some text depending on some date values, grouping them into date ranges of a week.
e.g.
1/1/07 SD
1/1/07 GH
3/1/07 FD
8/1/07 WE
1/2/07 JU
would become (Dates in this instance are week commencing values)
1/1/07 SD, GH, FD
8/1/07 WE
15/1/07
22/1/07
29/1/07 JU
5/2/07
12/2/07
Any pointers would be greatly appreciated