I run a report giving me the shift patterns of colleagues.
I need to break down what shift pattern they are on so forexample we have the following. So in the 1st columns I have in A 1and then in B & C I have those starting 1 then 2 in B and in C will bethose starting on 2 then 1 and then the 3 more for those on rotation 3.
Rotation 1 – standard Mon – Fri (
Rotation 2 – those who start their shift pattern this weekand those who started last week.
Rotation 3 ect.
So my requirement is that I need to put an identifier nextto the colleague to determine the column they will allocated to.
<tbody>
</tbody>
Not sue what the best option would be formula or VBA?
I need to break down what shift pattern they are on so forexample we have the following. So in the 1st columns I have in A 1and then in B & C I have those starting 1 then 2 in B and in C will bethose starting on 2 then 1 and then the 3 more for those on rotation 3.
Rotation 1 – standard Mon – Fri (
Rotation 2 – those who start their shift pattern this weekand those who started last week.
Rotation 3 ect.
So my requirement is that I need to put an identifier nextto the colleague to determine the column they will allocated to.
| Rotations | Shift Date | Shift Day | Shift Start | Shift End | Shift Hours | Shift Pattern ID |
| 1 | 26/11/2018 | Monday | 09:00 | 17:00 | 7 | 1 |
| 1 | 26/11/2018 | Monday | 09:00 | 17:00 | 7 | 1 |
| 1 | 26/11/2018 | Monday | 09:00 | 17:00 | 7 | 1 |
| 3 | 26/11/2018 | Monday | 09:00 | 17:30 | 7.5 | 4 |
| 2 | 19/11/2018 | Monday | 08:00 | 16:30 | 8 | 3 |
| 2 | 26/11/2018 | Monday | 09:00 | 17:30 | 8 | 2 |
| 1 | 27/11/2018 | Tuesday | 07:45 | 17:15 | 9 | 1 |
| 2 | 19/11/2018 | Monday | 07:00 | 16:00 | 8 | 3 |
| 2 | 19/11/2018 | Monday | 08:30 | 17:00 | 7.75 | 3 |
| 2 | 26/11/2018 | Monday | 08:15 | 16:30 | 7.75 | 2 |
| 3 | 12/11/2018 | Monday | 08:00 | 16:30 | 7.5 | 6 |
| 3 | 13/11/2018 | Tuesday | 09:00 | 17:30 | 7.5 | 6 |
| 3 | 19/11/2018 | Monday | 09:00 | 11:00 | 2 | 5 |
Not sue what the best option would be formula or VBA?
