Spreadsheet: 673975d1587616545-shrinking-list-that-can-be-used-multiple-times-excelformula-work
Sheet: Legacy posting

FIRST NAME | TRAINING/UNTASKED DAYS | 2020-02-16 00:00:00 | 2020-02-17 00:00:00 | 2020-02-18 00:00:00 | 2020-02-19 00:00:00 | 2020-02-20 00:00:00 | 2020-02-21 00:00:00 | 2020-02-22 00:00:00 | 2020-02-23 00:00:00 | 2020-02-24 00:00:00 | 2020-02-25 00:00:00 | 2020-02-26 00:00:00 | 2020-02-27 00:00:00 | 2020-02-28 00:00:00 | 2020-02-29 00:00:00 |  |  |  |  | job Selection list
[NAME] | #N/A | JOB1 | JOB1 | JOB1 | TRN | TRN | BRK | BRK | JOB1 | JOB1 | JOB1 | JOB1 | TRN | BRK | BRK
[NAME] | #N/A | BRK | BRK | BRK | TRN | TRN | BRK | BRK | JOB3 | APPT1 | APPT1 | JOB9 | TRN | BRK | BRK |  |  |  |  | ADMIN
Jamison | #N/A | JOB3 | JOB3 | TRN1 | TRN | TRN | BRK | BRK | JOB9 | JOB3 | TRN1 | TRN1 | TRN | BRK | BRK |  |  |  |  | APPT1
Micah | #N/A | [NAME] | [NAME] | TRN | TRN | TRN | BRK | BRK | TRN3 | [NAME] | [NAME] | [NAME] | TRN | BRK | BRK |  |  |  |  | APPT2
[NAME] | #N/A | TRN | [NAME] | [NAME] | TRN | TRN | BRK | BRK | [NAME] | [NAME] | JOB3 | APPT1 | TRN | BRK | BRK |  |  |  |  | APPT3
[NAME] | #N/A |  |  |  |  |  |  | BRK | JOB22 | JOB22 | JOB22 | JOB22 | TRN | BRK | BRK |  |  |  |  | APPT4
[NAME] | #N/A |  |  |  |  | JOB25 | JOB25 | JOB25 | JOB25 | JOB25 | JOB25 | JOB25 | JOB25 | JOB25 | JOB25 |  |  |  |  | APPT5
Logan | #N/A | JOB11 | JOB11 | APPT1 | APPT2 | TRN | BRK | BRK | [NAME] | [NAME] | [NAME] | JOB11 | TRN | BRK | BRK |  |  |  |  | APPT6
[NAME] | #N/A | JOB17 | [NAME] | JOB19 | TRN | TRN | BRK | BRK | JOB8 | [NAME] | JOB4 | TRN | TRN | BRK | BRK |  |  |  |  | BRK
Zack | #N/A | TRN | [NAME] | JOB19 | TRN | TRN | BRK | BRK | JOB8 | [NAME] | JOB4 | TRN1 | TRN | BRK | BRK |  |  |  |  | BRK1
[NAME] | #N/A | [NAME] | JOB10 | JOB12 | TRN | TRN | BRK | BRK | TRN1 | TRN1 | JOB10 | JOB4 | TRN | BRK | BRK |  |  |  |  | [NAME]
[NAME] | #N/A | JOB13 | JOB18 | JOB15 | TRN | TRN | BRK | BRK | JOB13 | JOB15 | JOB18 | JOB13 | TRN | BRK | BRK |  |  |  |  | BRK3
Dakota | #N/A | JOB9 | JOB9 | JOB3 | TRN | TRN | BRK | BRK | JOB11 | TRN3 | TRN3 | JOB3 | TRN | BRK | BRK |  |  |  |  | JOB1
Jordan | #N/A | TRN2 | JOB19 | JOB13 | TRN | TRN | BRK | BRK | JOB17 | JOB13 | [NAME] | JOB15 | TRN | BRK | BRK |  |  |  |  | [NAME]
[NAME] | #N/A | JOB21 | JOB7 | JOB17 | TRN | TRN | BRK | BRK | [NAME] | JOB8 | JOB7 | JOB7 | TRN | BRK | BRK |  |  |  |  | JOB3
Jordan | #N/A |  |  |  | TRN | TRN | BRK | BRK | TRN2 | TRN | JOB13 | JOB21 | TRN | BRK | BRK |  |  |  |  | JOB4
Micah | #N/A | [NAME] | JOB8 | [NAME] | TRN | TRN | BRK | BRK | [NAME] | TRN | TRN2 | TRN2 | TRN | BRK | BRK |  |  |  |  | [NAME]
Brooklyn | #N/A | JOB15 | JOB15 | JOB10 | TRN | TRN | BRK | BRK | JOB10 | G1B | JOB17 | JOB12 | TRN | BRK | BRK |  |  |  |  | [NAME]
[NAME] | #N/A | JOB10 | JOB13 | [NAME] | TRN | TRN | BRK | BRK | JOB12 | JOB19 | JOB15 | JOB17 | TRN | BRK | BRK |  |  |  |  | JOB7
[NAME] | #N/A | JOB19 | JOB21 | JOB16 | TRN | TRN | BRK | BRK | JOB21 | JOB17 | [NAME] | JOB18 | TRN | BRK | BRK |  |  |  |  | JOB8
Dayton | #N/A | JOB16 | [NAME] | JOB18 | TRN | TRN | BRK | BRK | [NAME] | JOB18 | JOB12 | [NAME] | TRN | BRK | BRK |  |  |  |  | JOB9
[NAME] | #N/A | JOB18 | JOB12 | TRN | TRN | TRN | BRK | BRK | JOB16 | JOB21 | JOB19 | JOB16 | TRN | BRK | BRK |  |  |  |  | JOB10
[NAME] | #N/A | TRN1 | TRN | JOB21 | TRN | TRN | BRK | BRK | JOB19 | JOB16 | JOB21 | JOB19 | TRN | BRK | BRK |  |  |  |  | JOB11
[NAME] | #N/A | [NAME] | JOB16 | [NAME] | TRN | TRN | BRK | BRK | JOB18 | [NAME] | JOB16 | G1B | TRN | BRK | BRK |  |  |  |  | JOB12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRN1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRN2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRN3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRN5