Spreadsheet: 834329d1687681087-stopping-duplication-of-a-index-formula-test-3-1-
Sheet: Sheet1

Date | Rota |  |  |  |  |  |  | People off |  |  |  |  |  |  | Leave |  |  |  |  |  |  |  |  |  |  |  |  | Intials
 | Night shift | CXH shift | SMH Day shift | CXH Day shift | HH Day shift |  |  | Post night shift | Post night shift | Post night shift | Post night | Post Weekend day | Post Weekend day | Post Weekend day |  |  |  |  |  |  |  |  |  |  |  |  |  | JM
2023-08-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JK | ADS |  |  |  |  |  |  |  |  |  |  |  | AM
2023-08-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JK | ADS |  |  |  |  |  |  |  |  |  |  |  | KUR
2023-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JK | NO | TT | ADS | JM |  |  |  |  |  |  |  |  | KK
2023-08-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JK | TT | ADS | JM |  |  |  |  |  |  |  |  |  | JK
2023-08-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JK | CC | TT | ADS |  |  |  |  |  |  |  |  |  | NO
2023-08-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JK |  |  |  |  |  |  |  |  |  |  |  |  | CW
2023-08-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | JW | RG | ET | NA | PGT |  |  |  |  |  |  |  | JW
2023-08-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SL |  |  |  |  |  |  |  |  |  |  |  |  | ZH
2023-08-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KK | RR |  |  |  |  |  |  |  |  |  |  |  | AKS
2023-08-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | KK | RR |  |  |  |  |  |  |  |  |  |  | BV
2023-08-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RB | KK | HP | JM | RR |  |  |  |  |  |  |  |  | SC
2023-08-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CQ | RB | KK | HP | JM | RR |  |  |  |  |  |  |  | CC
2023-08-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CQ | TT | KK |  |  |  |  |  |  |  |  |  |  | EH
2023-08-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CQ | ET | AL |  |  |  |  |  |  |  |  |  |  | AJ
2023-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CQ | ASH | AL |  |  |  |  |  |  |  |  |  |  | CQ
2023-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ASH | AL |  |  |  |  |  |  |  |  |  |  |  | KR
2023-08-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | ASH | SC | AL |  |  |  |  |  |  |  |  |  | ASH
2023-08-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RB | ASH | SC | AL |  |  |  |  |  |  |  |  |  | ET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ASK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PSW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CM