Hi,
I have list of different dates in Column B , I want o/p in column C as below(If 2 cell of continuous raw having same date then in o/p of cell 1st must be same date & second date having +1 date,)
Example : in Raw 3,4,5 person A having same date in column B ( 10th Jan) , O/p must be like .. Raw 3 : 10th ,Raw 4: 11th ,Raw 5 : 12th.
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
I have list of different dates in Column B , I want o/p in column C as below(If 2 cell of continuous raw having same date then in o/p of cell 1st must be same date & second date having +1 date,)
Example : in Raw 3,4,5 person A having same date in column B ( 10th Jan) , O/p must be like .. Raw 3 : 10th ,Raw 4: 11th ,Raw 5 : 12th.
Raw 1 | Column A | Column B | Column C |
Raw 2 | Person | Data | O/P |
Raw 3 | A | 10-Jan | 10-Jan |
Raw 4 | A | 10-Jan | 11-Jan |
Raw 5 | A | 10-Jan | 12-Jan |
Raw 6 | B | 11-Jan | 11-Jan |
Raw 7 | B | 11-Jan | 12-Jan |
Raw 8 | C | 10-Jan | 10-Jan |
Raw 9 | C | 10-Jan | 11-Jan |
Raw 10 | C | 10-Jan | 12-Jan |
Raw 11 | C | 10-Jan | 13-Jan |
Raw 12 | C | 10-Jan | 14-Jan |
Raw 13 | C | 10-Jan | 15-Jan |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>