Spreadsheet: 734210d1622038479-excel-shift-formula-june-21c
Sheet: Formula

 | Employee |  | Available Names with blanks sorted to bottom |  |  |  |  |  |  |  |  |  |  |  | Available Names (Row Count)
 |  |  | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 |  | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11
 | [NAME] |  | Tillman | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 3
 | Anchissi |  | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | Anchissi |  |  |  |  |  |  |  |  |  |  |  | 4
 | Rosales |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Rosales |  |  |  |  |  |  |  |  |  |  |  | 5
 | Deroche |  | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | Deroche |  |  |  |  |  |  |  |  |  |  |  | 6
 | Dupont |  | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Dupont |  |  |  |  |  |  |  |  |  |  |  | 7
 | Michel |  | 5 |  |  |  |  |  |  |  |  |  | Michel |  |  |  |  |  |  |  |  |  |  |  | 8
 | Schaff |  |  |  |  |  |  |  |  |  |  |  | Schaff |  |  |  |  |  |  |  |  |  |  |  | 9
 | Ferrell |  |  |  |  |  |  |  |  |  |  |  | Ferrell |  |  |  |  |  |  |  |  |  |  |  | 10
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 11
 | Caragliano |  |  |  |  |  |  |  |  |  |  |  | Caragliano |  |  |  |  |  |  |  |  |  |  |  | 12
 | Pepitone |  |  |  |  |  |  |  |  |  |  |  | Pepitone |  |  |  |  |  |  |  |  |  |  |  | 13
 | Killian |  |  |  |  |  |  |  |  |  |  |  | Killian |  |  |  |  |  |  |  |  |  |  |  | 14
 | Snakenberg |  |  |  |  |  |  |  |  |  |  |  | Snakenberg |  |  |  |  |  |  |  |  |  |  |  | 15
 | J Dimaggio |  |  |  |  |  |  |  |  |  |  |  | J Dimaggio |  |  |  |  |  |  |  |  |  |  |  | 16
 | Eddleman |  |  |  |  |  |  |  |  |  |  |  | Eddleman |  |  |  |  |  |  |  |  |  |  |  | 17
 | Ledet |  |  |  |  |  |  |  |  |  |  |  | Ledet |  |  |  |  |  |  |  |  |  |  |  | 18
 | P Bacino |  |  |  |  |  |  |  |  |  |  |  | P Bacino |  |  |  |  |  |  |  |  |  |  |  | 19
 | Tillman |  |  |  |  |  |  |  |  |  |  |  | Tillman |  | 20 |  |  |  |  |  |  |  |  |  | 20
 | Hellmers |  |  |  |  |  |  |  |  |  |  |  | Hellmers |  |  |  |  |  |  |  |  |  |  |  | 21
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 22
 | Bentley |  |  |  |  |  |  |  |  |  |  |  | Bentley |  |  |  |  |  |  |  |  |  |  |  | 23
 | Graffato |  |  |  |  |  |  |  |  |  |  |  | Graffato |  |  |  |  |  |  |  |  |  |  |  | 24
 | Ayo |  |  |  |  |  |  |  |  |  |  |  | Ayo |  |  |  |  |  |  |  |  |  |  |  | 25
 | Hastings |  |  |  |  |  |  |  |  |  |  |  | Hastings |  |  |  |  |  |  |  |  |  |  |  | 26
 | Boudreaux |  |  |  |  |  |  |  |  |  |  |  | Boudreaux |  |  |  |  |  |  |  |  |  |  |  | 27
 | Palmisano |  |  |  |  |  |  |  |  |  |  |  | Palmisano |  |  |  |  |  |  |  |  |  |  |  | 28
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 29
 | Adams |  |  |  |  |  |  |  |  |  |  |  | Adams |  |  |  |  |  |  |  |  |  |  |  | 30
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 31
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 32
 | Paisant |  |  |  |  |  |  |  |  |  |  |  | Paisant |  |  |  |  |  |  |  |  |  |  |  | 33
 | Dunn |  |  |  |  |  |  |  |  |  |  |  | Dunn |  |  |  |  |  |  |  |  |  |  |  | 34
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 35
 | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36
 | 2 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
 | 3 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38
 | 4 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 39 | 39 | 39 | 39 | 39 | 39 | 39 | 39 | 39 | 39 | 39
 | 5 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
 |  |  | Above table pulls names from row numbers given in equivalent table, sorting by using INDEX(..SMALL) functions |  |  |  |  |  |  |  |  |  |  |  | Above table checks against names that have been already allocated for the given day
 |  |  | Worksheet names for columns are defined using variable formulas to only contain non-empty ( "") cells, and then used in validation formulas |  |  |  |  |  |  |  |  |  |  |  | If a name has not been used it's row number is listed so the equivalent table knows what row to pull the name