Spreadsheet: 692634d1598470513-formula-to-evaluate-two-criteria-and-pull-data-if-both-met-scheduling-dummy-file
Sheet: Server Availability_OLD

Shift | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Notes |  |  |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
AM Shift |  |  |  |  |  |  |  |  |  |  | 2
"AM" SERVERS ONLY |  |  |  |  |  |  |  |  |  |  | 3
DO NOT CUT OR |  |  |  |  |  |  |  |  |  |  | 4
COPY AND PASTE!!! |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  | 6
Do NOT mix names |  |  |  |  |  |  |  |  |  |  | 7
in single rows! |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | 9
Enter servers |  |  |  |  |  |  |  |  |  |  | 10
by using the drop |  |  |  |  |  |  |  |  |  |  | 11
down selectors!! |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  | 15
"AM" SERVERS ONLY |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  | 23
"AM" SERVERS ONLY |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  | 31
Noon/Midday Shift |  |  |  |  |  |  |  |  |  |  | 33
"MID" SERVERS ONLY |  |  |  |  |  |  |  |  |  |  | 34
DO NOT CUT OR |  |  |  |  |  |  |  |  |  |  | 35
COPY AND PASTE!!! |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  | 37
Do NOT mix names |  |  |  |  |  |  |  |  |  |  | 38
in single rows! |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  | 40
Enter servers |  |  |  |  |  |  |  |  |  |  | 41
by using the drop |  |  |  |  |  |  |  |  |  |  | 42
down selectors!! |  |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  | 47
"MID" SERVERS ONLY |  |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  |  |  | 57
"MID" SERVERS ONLY |  |  |  |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  |  |  | 65
PM Shift |  |  |  |  |  |  |  |  |  |  | 67
"PM" SERVERS ONLY |  |  |  |  |  |  |  |  |  |  | 68
DO NOT CUT OR |  |  |  |  |  |  |  |  |  |  | 69
COPY AND PASTE!!! |  |  |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  | 71
Do NOT mix names |  |  |  |  |  |  |  |  |  |  | 72
in single rows. |  |  |  |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  |  |  |  | 74
Enter servers |  |  |  |  |  |  |  |  |  |  | 75
by using the drop |  |  |  |  |  |  |  |  |  |  | 76
down selectors!! |  |  |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  | 81
"PM" SERVERS ONLY |  |  |  |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  |  | 84
 |  |  |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  |  | 87
 |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  | 89
"PM" SERVERS ONLY |  |  |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  | 91
 |  |  |  |  |  |  |  |  |  |  | 92
 |  |  |  |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  |  |  |  | 97
 |  |  |  |  |  |  |  |  |  |  | 98
 |  |  |  |  |  |  |  |  |  |  | 99
 |  |  |  |  |  |  |  |  |  |  | 100
 | Employee List (DO NOT ENTER DATA; THIS AUTOMATICALLY POPULATES FROM ABOVE)