Shift pattern conversion

[nbrown6]

Hi All,

For some reason this problem is getting the better of me and i cannot find a way around it.

I have a column of week numbers, one of the shift and i want to add a column shift the team working at that time. We have a permanent night shift and the other day shifts swap from earlies to lates on alternate weeks.

No matter what 'AND 'OR 'IF or 'IFS formulas i use i cannot get the result i want. No matter what i search online i cannot even point myself in the right direction

Week	Shift	Team
1	Early	A
1	Lates	B
1	Nights	N
2	Early	B
2	Lates	A
2	Nights	N

[Paul_Hossler]

Assuming "Week" is in row 1

=CHOOSE(MOD(ROW()-1,6)+1,"N","A","B","N","B","A")

Capture.JPG