Same date problem in Column.

[EC_08]

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.

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>

 

[steve the fish]

In D3:

=C3

In D4:

=IF(C3=C4,D3+1,C4)

Drag down from D4 to end of data.

 

[steve the fish]

In fact thinking about it this works in D3 dragged down as long as you always have headers:

=IF(C2=C3,D2+1,C3)