Formula to insert shift daywise

Hi - I have a set of rows which has column 'shift' missing. I need to fill the column 'shift' based on the date, for example -

# Date Shift
1 01/04/2014 A
2 02/04/2014 A
3 02/04/2014 B
4 03/04/2014 A
5 03/04/2014 B
6 03/04/2014 C
7 04/04/2014 A
8 04/04/2014 B


etc.


Kindly help to write a formula for filling in the shifts for every dates.

Thanks
MK

Originally Posted by akashmenon

Hi - I have a set of rows which has column 'shift' missing. I need to fill the column 'shift' based on the date, for example -

# Date Shift
1 01/04/2014 A
2 02/04/2014 A
3 02/04/2014 B
4 03/04/2014 A
5 03/04/2014 B
6 03/04/2014 C
7 04/04/2014 A
8 04/04/2014 B


etc.


Kindly help to write a formula for filling in the shifts for every dates.

Thanks
MK

Based on your data, I used this formula:

=IF(A3=A2,CHAR(CODE(B2)+1),CHAR(65))

and got same results. Note, I could have used "A" instead of char(65)

Thanks for the reply. Looks, I have not explained properly -

The data has a date and the shift. For each date there can be three shifts i.e. 'A', 'B' and 'C'. I need to fill the shifts based on the dates. for example the data below -

02-Sep-13 A
03-Sep-13 A
04-Sep-13 A
05-Sep-13 A
06-Sep-13 A
06-Sep-13 B
07-Sep-13 A
07-Sep-13 B
10-Sep-13 A
11-Sep-13 A
11-Sep-13 B
12-Sep-13 A
13-Sep-13 A
14-Sep-13 A
14-Sep-13 B
14-Sep-13 C
16-Sep-13 A
02-Oct-13 A
02-Oct-13 A

Kindly let me have a formula for this.

Regards,
Murali

Originally Posted by akashmenon

Thanks for the reply. Looks, I have not explained properly -

The data has a date and the shift. For each date there can be three shifts i.e. 'A', 'B' and 'C'. I need to fill the shifts based on the dates. for example the data below -

02-Sep-13 A
03-Sep-13 A
04-Sep-13 A
05-Sep-13 A
06-Sep-13 A
06-Sep-13 B
07-Sep-13 A
07-Sep-13 B
10-Sep-13 A
11-Sep-13 A
11-Sep-13 B
12-Sep-13 A
13-Sep-13 A
14-Sep-13 A
14-Sep-13 B
14-Sep-13 C
16-Sep-13 A
02-Oct-13 A
02-Oct-13 A

Kindly let me have a formula for this.

Regards,
Murali

I apologize. I have no idea what you are trying to do. Is there some sort of before and after data? Is what you posted the before? If so, what is the data after?