I posted a question here yesterday with no replies so I thought I would simplify the question and ask again. I really need some help with the following:
I start with Original Value, Start, End, and generate the New Value.
Original Value Start End New Value
A 7/1/2007 8/3/2008 A, B
B 7/1/2007 8/5/2008 A, B, C
C 10/1/2007 8/5/2008 B, C, D
D 8/3/2008 9/3/2008
New Value explanation:
A & B are concatenated because they have the same start date and they have not reached their end date.
A, B, C are concatenated because C's Start <> B's Start and they have not reached an End.
A is dropped because D's start is >= to A's End.
Original question found here:
http://www.mrexcel.com/forum/showthread.php?t=490431&highlight=sheri100
Thanks is advance for any help.
I start with Original Value, Start, End, and generate the New Value.
Original Value Start End New Value
A 7/1/2007 8/3/2008 A, B
B 7/1/2007 8/5/2008 A, B, C
C 10/1/2007 8/5/2008 B, C, D
D 8/3/2008 9/3/2008
New Value explanation:
A & B are concatenated because they have the same start date and they have not reached their end date.
A, B, C are concatenated because C's Start <> B's Start and they have not reached an End.
A is dropped because D's start is >= to A's End.
Original question found here:
http://www.mrexcel.com/forum/showthread.php?t=490431&highlight=sheri100
Thanks is advance for any help.