Hi, this is teh first time I am posting on this site. I have been here before have has found help in figuring out complex calculations. So I am here again, this time as a member, requesting help to figure out a formula that has me baffled.
I have a whole spreadsheet full of data like that given below.
It shows the date someone was called in column B and the date the person attended in Column C.
As you can see the "Call Date" for all unique "Names" are identical where as the "Attended Date" varies.
What I need is to extract in a different sheet the "Attended Date" that is immediately after the "Call Date" for each unique individual.
E.g
A2= Fred, B2= 17-Jan-16, C2= 29-Jan-16 (the 1st date in "Attended Date" this is common for Fred, after 17-Jan-1)
A3= Hank, B3= 7-Feb-16, C3= 4-Mar-16 (the 1st date in "Attended Date" this is common for Hank, after 7-Feb-16)
A4= John, B4= 25-Feb-16, C4= 1-Mar-16 (the 1st date in "Attended Date" this is common for John, after 25-Feb-16)
and so on.
Please help, am on the clock.
<tbody>
</tbody>
I have a whole spreadsheet full of data like that given below.
It shows the date someone was called in column B and the date the person attended in Column C.
As you can see the "Call Date" for all unique "Names" are identical where as the "Attended Date" varies.
What I need is to extract in a different sheet the "Attended Date" that is immediately after the "Call Date" for each unique individual.
E.g
A2= Fred, B2= 17-Jan-16, C2= 29-Jan-16 (the 1st date in "Attended Date" this is common for Fred, after 17-Jan-1)
A3= Hank, B3= 7-Feb-16, C3= 4-Mar-16 (the 1st date in "Attended Date" this is common for Hank, after 7-Feb-16)
A4= John, B4= 25-Feb-16, C4= 1-Mar-16 (the 1st date in "Attended Date" this is common for John, after 25-Feb-16)
and so on.
Please help, am on the clock.
Name | Call Date | Attended Date |
Fred | 17-Jan-16 | 11-Jan-16 |
Fred | 17-Jan-16 | 29-Jan-16 |
Fred | 17-Jan-16 | 13-Mar-16 |
Fred | 17-Jan-16 | 14-Mar-16 |
Fred | 17-Jan-16 | 14-Mar-16 |
Hank | 7-Feb-16 | 1-Jan-16 |
Hank | 7-Feb-16 | 4-Mar-16 |
Hank | 7-Feb-16 | 22-Mar-16 |
John | 25-Feb-16 | 2-Jan-16 |
John | 25-Feb-16 | 9-Feb-16 |
John | 25-Feb-16 | 1-Mar-16 |
John | 25-Feb-16 | 6-Mar-16 |
<tbody>
</tbody>