Spreadsheet: 792347d1660843967-looking-for-formula-help-to-list-a-persons-name-based-on-a-number-matching-a-column-attendance-2022-gce
Sheet: Today

WC | CR1 | 2022-08-12 00:00:00 | Headcount | Operator | Current Status | Daily Expected | 4:00AM - 6:00AM | [NAME] | 8:00AM - 10:00AM | 10:00AM - 12:00PM | 12:00PM - 2:00PM | 2:00PM - 4:00PM | 4:00PM - 6:00PM | 6:00PM - 8:00PM | 8:00PM - 10:00PM | 10:00PM - 12:00AM | 12:00AM - 2:00AM | 2:00AM - 4:00AM |  |  |  |  |  | 1 st WC | 2nd WC | 3rd WC | 4th WC | 5th WC | Today's Employees
1 | [NAME] | #N/A | 0.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 33 | 15 | 35 |  | [NAME]
2 | [NAME] | [NAME] | 0.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 50 | 20 | 7 |  | [NAME]
3 | [NAME] | #[NAME]? | 0.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 97 | 13 | 3 |  | Beatriz [NAME]
4 | [NAME] | [NAME] | 0.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 19 | 11 | 4 |  | Alfonzo Cortez
5 | [NAME] | [NAME] | 0.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 9 |  | Breon Fields
6 | 0 | [NAME] | 0.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
7 | Architect SC | Arch Sample Cup | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
8 | [NAME] | [NAME] | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Catalina Salgado
9 | [NAME] | [NAME] | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
10 | [NAME] | [NAME] | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
11 | 0 | Alinity Sample Cup | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Usha [NAME]
12 | Luminex/Baxter | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
13 | Luminex/Baxter | Abbvie NSPD EQP | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
15 | Abbott/Siemens | Lid Tray | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
16 | [NAME] | [NAME] | 0.25
17 | [NAME] | [NAME] | 0.25
18 | [NAME] | [NAME] | 0.25
19 | [NAME] | [NAME] | 0.25
20 | Siemens | Base Tray | 0.25
21 | [NAME] | [NAME] | 0
22 | [NAME] | [NAME] | 0.25
23 | [NAME] | [NAME] | 0.25
30 | [NAME] | [NAME] | 0.25
31 | [NAME] | [NAME] | 0.25
50 | Baxter SIV Assy | Baxter SIV Assy | 0
97 | NSPD | 0 | 0
Total |  |  | 6
 | CR2
52 | Architect RV | [NAME] | 0.25
53 | Architect RV | [NAME] | 0.25
54 | Siemens | Siemens KS860 | 0.25
58 | Architect RV | [NAME] | 0.25
59 | Architect RV | [NAME] | 0.25
61 | [NAME] | Lid Tray | 0.5
62 | NP227 | NP229 OQ | 0
63 | NP Medical | NP 225 ES | 0
64 | NP Medical/Siemens | NP 226 | QI
66 | [NAME] | Base Tray | 0.5
67 | [NAME] | NP 228 | QI
68 | [NAME] | Base Cassette | 0
69 | [NAME] | Top Frame C IQP | 0
71 | [NAME] | K103 | QI
72 | [NAME] | Siemens Capillary Tube | 0
73 | [NAME] | 0 | 0
74 | [NAME] | Side Cassette A | 0.25
76 | [NAME] | 0 | 0
77 | [NAME] | PCR Tube ES | 0
78 | [NAME] | [NAME] | 0
79 | Luminex/NP Medical/Roche | V102 | QI
86 | 0 | 0 | 0
87 | [NAME] | 0 | 0
88 | [NAME] | [NAME] | 0
89 | [NAME] | [NAME] | QI
95 | 0 | 0 | 0
96 | NP Medical | 0 | 0
99 | [NAME] shell key assembly | 0 | 0
106 | [NAME] shell key assembly | [NAME] Key8 Orange | 0.5
107 | Snap Ring | Alinity Snap Ring | 0
108 | [NAME] shell | [NAME] Key3 White | 0.25
109 | Abbott/Baxter | [NAME] cav Neck | 0.25
Total |  |  | 4
0 | [NAME] | [NAME] | 1
0 | Total |  | 11
 | Actual Headcount |  | 11
 | Key
 | Headcount verified
[NAME] | Running
[NAME] | Not Running
[NAME] | Setup/Shutdown
[NAME] | Maintenance
Mark