Spreadsheet: 711807d1609923827-pulling-one-of-multiple-headers-in-single-column-based-on-information-below-schedule-gk-06-01-0900
Sheet: Master Schedule

Valid from: | Master sheet feeding the daily schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dates for dropdown |  |  | Day | Abbreviation
2021-01-17 00:00:00 | This cell drives everything in the sheet!! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sun | Su
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mon | M
Selected date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tue | [NAME]
2021-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wed | W
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thu | Th
Name 1 | P | A |  | A | A | A |  |  |  | A |  |  | A |  | P | A | P | P |  |  | A | A | A | P | P |  | A |  | A |  |  |  | A | A |  | A |  |  | A | A |  | A |  |  |  |  |  |  |  | Fri | F
Name 2 |  |  |  | A | A | A |  |  |  | P | A | A | A | A |  | P |  | A |  | A | A | A | A |  |  | A |  | P | A | A | A |  | A |  |  |  | A |  |  |  | A |  |  |  |  |  |  |  |  | Sat | Sa
Name 3 |  |  |  | P | A | P |  |  | A | A | A | A | P | A | A |  |  | P | P | P | A |  | P | A |  |  | A | A |  | P |  |  | P |  | P | A |  | P | A |  | P | P
Name 4 |  |  | A | P | P |  | A |  | A |  | P |  | A | A |  |  |  | A | P |  |  | P | A |  |  | P | A | A |  | P |  | P | P |  | A | A | A | A | P
Name 5 | A |  |  | P | P |  | A |  |  | P | P | A |  |  | P | A | P |  | P | A | P |  |  | P |  |  | P |  |  |  |  |  | P | P | P |  |  | P |  |  |  | P
Name 6 |  |  | P | P |  | P | A |  |  |  |  | A |  |  |  | P | A | A |  |  |  |  | P |  |  |  | A |  | P |  | A | A |  | A | P |  | P | P | P |  |  | P
Name 7 |  | P |  | A | A | A | A |  |  | A |  | A | P |  |  |  |  | A | P |  | A |  | P | A | P |  | P |  |  | P |  |  |  | P | P |  | A | A | P
Name 8 |  |  | A |  |  |  | P | A | A | A | P |  |  | P | A |  | A |  |  | A | A | A | P |  | P |  |  |  |  | A | P | A | A | P |  | A |  | A |  |  | P | P
Name 9 |  |  |  | P | A | A | P |  |  | P | A |  |  | P |  | P | P | A |  | A | P |  |  | P |  | P | A |  | A | A |  | P | P |  | P | A | P | P | P | A | P | A
Name 10 |  | P |  |  | A | A |  | A | P |  | A |  |  |  | P |  | P |  | A |  | A | A | P | P | A |  |  | A | A | A | A | A | A | P | P |  |  |  |  | P
Name 11 | P |  | A | P | A |  | P | A |  |  |  |  |  |  |  | A |  |  |  |  | P |  | P |  | A |  |  |  | A | A |  | P | P |  |  | P |  |  | A | A | A | P
Name 12 |  |  |  | A |  | A | A |  |  |  |  |  | P |  |  | A |  |  | P |  |  | A |  | A | A |  | A | A |  |  | A |  | P | A | A | P | P |  | A |  | P
Name 13 |  | A |  |  | P |  | P |  | A | P | A |  | P |  | P |  | P |  | P |  |  |  |  |  |  |  |  |  |  | A | A |  | A | P |  |  |  | A |  | P | A | P
Name 14 |  |  |  | P |  |  |  | P | A | P |  |  |  |  | P |  | P |  |  | P |  |  |  |  | P |  | P |  | P |  |  | A | A | A | P |  |  |  | P | A | P | A
Name 15 |  | P |  | P |  |  |  | P |  |  | P |  |  |  |  |  |  |  | A |  | A | A |  |  |  |  | A | P |  |  |  | P |  | A | A |  | P | A | P |  | A | P
Name 16 |  | P | P |  |  |  | P |  | P |  |  | P |  |  | P |  | A | P |  | A |  | P |  | P | P | A |  |  |  | P | P | A |  | A |  | A |  | A |  | P | A
Name 17 |  |  | P |  |  |  |  |  | P |  | A |  | A | A |  | P | A | A |  |  | P | A |  |  | A |  | P |  | P |  | P |  |  | P |  |  |  | P | A | A
Name 18 |  | A |  | A |  | P |  |  |  |  |  |  | A | A |  |  |  | A |  |  | A | A |  |  |  |  |  |  | P | P |  |  | A | A | P |  | A |  |  |  | A | A
Name 19 |  | A | A |  |  |  | A |  | P | A |  | P |  |  |  |  |  |  |  | A |  | A |  | A | P |  | P | A |  | A |  | A |  |  | P |  | A |  | P | A | A
Name 20 | A | A |  |  | P | A |  | P | P | P | A |  |  | A | P |  | P |  | A |  | P | P |  | A |  |  | P |  | A |  |  | A | P |  |  | A |  |  |  | P | A
Name 21 | A |  | P |  | P | A |  | P |  | A | P | P | A |  |  | A | P | P |  | A |  |  | A | A | P |  |  | P |  |  | A |  | A | P | P |  |  |  | P |  |  | A
Name 22 | A |  |  |  | A |  |  | A | A |  |  | A | P | P | P | P | P | A | P |  | A |  |  | A | P | P | A | P |  |  | P |  |  |  | A | A |  | A |  | A |  | P
Name 23 | A | A |  | A | A | A |  | P | P | P |  |  | A |  |  | A |  | A | P | A | A |  | P | A |  | P | A | A | A |  | A | P |  | A |  |  | A |  | P |  |  | A
Name 24 |  | A |  |  | A | A | A |  |  |  |  | A |  |  |  | P |  |  | A |  | A |  |  |  | A |  |  |  | A |  |  | A | A | P | A | A | A |  | A | A | A
Name 25 | A | P | A | A |  | A |  |  | A | P |  | P | A | P |  | A | P |  |  | P |  |  |  |  | P | A |  |  | A | A |  | A |  |  |  | A |  | P | A |  | A
Name 26 |  |  | A |  |  | P |  |  | A |  | P |  |  | A | P |  |  |  |  | P |  | A | A |  |  | A |  | P |  |  |  |  |  | A |  |  |  | P | A | A |  | P
Name 27 | A |  |  | A | A | A | P | A | P |  | P | A |  |  | P |  |  | P |  |  |  | P |  |  |  |  |  |  | A |  | P |  |  | P | P | A |  | P |  | P |  | A
Name 28 |  |  | A | P |  | P |  |  | P |  |  |  | P | P | P | A | A |  | A | P | P | P |  |  | A | P | A | P | A |  | P | P | A | P |  |  | A |  |  | A
Name 29 | P | P |  | A | A |  |  | P |  | A |  | A | P |  |  |  | P | A | P |  |  |  |  |  | A | P |  | P | P | A |  |  |  |  |  | A | P | A |  |  | A | P
Name 30 |  |  | P |  |  |  |  |  | P | P |  |  | A |  |  | P | A | A | P |  |  |  |  |  |  |  |  |  |  |  |  |  | P | A | A | A | A
Name 31 |  | A |  |  | A | P |  | P | P | A |  |  |  | P | A |  |  |  |  |  | P | P |  | A |  | A | P |  |  | A |  | A | A |  |  |  | A | P | A | P
Name 32 | A | A | A | A | P | A |  | P |  |  |  | A | P |  | P |  | A | P |  |  | A |  |  | P |  |  | A |  | P |  |  |  |  | P |  |  | A | P | P |  | A
Name 33 |  |  | P | P | A |  |  |  |  | P |  | P | A |  | A |  |  |  | A |  |  | P | A | A | P | A |  | A | A |  |  |  | A |  | A | A | P |  |  | P | P | P
Name 34 |  | P |  |  | A | P |  | A | P | A |  | A |  | A |  | A | P |  |  | P |  | A | A |  | A | P | P |  | P |  |  | A | A | A | P | A | P |  | P
Name 35 |  | A |  |  |  | A |  | A | P | A | A | A | A |  | P | P | P | A | P | P | A |  | A |  |  | A | A |  |  |  |  |  | P | A |  | A |  |  |  |  |  | P
Name 36 |  |  |  | P | P |  | P |  | P |  | A |  | A | A |  | A | P |  | P |  |  | P |  | P | A |  | P |  |  | A | P | P | A | P |  |  | P | A | A | A | P | A
Name 37 | P |  |  | A |  | P |  | P |  | P |  |  | P |  | P |  |  |  | P |  | P |  |  |  |  | P | A | P |  |  | A | A | A | A | A |  |  | P | A | A
Name 38 | P | P |  |  |  | A | P | P |  |  | P | A |  | A | A |  |  | A | A | A | P |  | A | A |  |  | P |  | P | A | A | A | A |  | P |  | P |  | P | A
Name 39 | A | P | A | A |  |  |  |  |  | A |  | A |  | P |  | A | P |  | P | P | A | A |  |  |  |  | A | A |  |  |  | A |  |  | P |  |  | P | P | A |  | A
Name 40 | P |  | A | P | A | P | A |  | A | A |  |  |  | P |  |  |  |  | A |  |  | P |  |  | P | P | A | A |  |  | P |  | P |  |  |  | A |  |  |  |  | P
Name 41 |  |  | P |  | P |  | P |  | P | A | A |  |  |  |  |  |  |  |  | A |  | P | A |  | A | A |  |  | A | P |  | P |  | P |  | A |  | A |  | A |  | P
Name 42 | P | A |  |  |  | P |  |  | P |  |  | P | A |  | P | P |  |  | A |  | P |  | P | P | P | P | A | A | P | A | P |  |  | A |  | P | P |  | P | P |  | A
Name 43 |  |  |  |  | P |  | A | A |  |  | P |  | A |  | P |  | P | P |  | A | A | P | P | P |  |  | P | P | P | P | A | P |  | A | A |  | A | A |  | A | A | A
Name 44 | P | P | P |  |  |  |  |  | P |  |  | A |  | A | P |  |  |  | A | A |  | P | A |  | A |  | P | P |  | A | P | A |  |  | A | A |  |  |  | P
Name 45 |  |  | P | P | A |  | P |  |  |  |  |  | A | A | A | A | A |  | A | A |  | P |  |  | P | A | P | A | P |  |  |  | P | A | A |  | A | P |  | P | P | P
Name 46 |  |  |  |  |  |  |  | A |  | A |  |  | P |  |  |  | P | A |  | P | P | A |  | A |  | A | A | A | P |  |  |  |  | P | P |  |  | A
Name 47 |  |  |  |  | P |  |  |  | A |  | P | A | P |  |  | P |  |  |  |  | A | P | P | P |  | A |  | A | A |  |  | P
Name 48 |  |  | P | P |  |  | A | A |  |  |  | P | P |  | P | A | A |  | A | P |  | P |  | P |  | P |  | P | P | A | A |  |  |  |  |  | P |  |  | A | P | P
Name 49 |  | A |  | P |  |  |  |  |  | P | P |  |  | P | A | P |  | A |  | P | P | A |  | P | A |  | A | A |  | P | P | P |  | A | P |  | P | P |  | P
Name 50 |  | A |  | P |  |  | P |  |  |  |  | A |  |  |  |  | P |  | P | A | P |  | P | P |  | P |  | P |  | A | A | P | P |  | A | P | A | P |  |  |  | P
Name 51 |  | P |  |  | P |  |  |  |  |  | P |  | P | P | A |  | P |  |  |  | A | P | P | A | P | A | A | P |  |  |  |  |  | P | P |  | A |  |  | A
Name 52 |  |  |  | P |  |  | P |  |  |  |  | A |  | A | A | P | P | A | A | P |  | P |  |  |  |  | A | P |  | P |  |  |  | P | A |  |  |  |  | P | A
Name 53 |  | P |  | P |  |  | A |  |  |  |  |  |  | P |  | P |  |  |  |  | P | A |  | A |  | P | A |  | P | P |  | A |  |  | A |  | A | P |  | A | A | P
Name 54 |  |  | P |  | A |  |  | P |  | A | A |  |  | A |  | A | A | A | P |  |  | A |  | P | A |  | A | A |  | A | P |  | A | P | A | P | P | A | P |  | P | P
Name 55 |  |  | P |  | P | A | A |  | P |  |  |  | A | A |  |  | P |  | P | A |  | P | A | P | A | P | A |  | A | P | A |  |  |  |  | P | P |  | P | P | A
Name 56 | A |  |  |  |  |  | P |  |  |  |  |  |  | P | A | P | A |  |  | A |  |  | P | A |  | P |  | A |  |  |  | A |  | P | P |  | P | A |  | P |  | P
AM
PM