Spreadsheet: 691974d1597986828-use-formula-to-auto-sort-cells-in-range-with-blanks-at-bottom-or-ignored-example1835
Sheet: Server Availabiliy

Rank | First Name | Last Name | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Shift | Name | Status |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Rank (S) | Rank (M) | Rank (T) | Rank (W) | Rank (H) | Rank (F) | Rank (ST) | Repeats (S) | Repeats (M) | Repeats (T) | Repeats (W) | Repeats (H) | Repeats (F) | Repeats (ST) | Rank+ (Sun) | Rank+ (Mon) | Rank+ ([NAME]) | Rank+ (Wed) | Rank+ (Thurs) | Rank+ (Fri) | Rank+ (Sat) |  | Rank | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Sunday
1 |  |  | Yes |  | Yes | Yes | Yes |  | Yes | 2 | AM |  | Yes | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | Yes | Yes | Yes | Yes | Yes |  | Yes | 3 | MID |  | Yes | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | Yes | Yes | Yes | Yes | Yes |  | Yes | 4 | PM |  | Yes | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
2 |  |  | Yes | Yes | Yes |  | Yes |  | Yes | 5 | AM |  | Yes | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  | Yes | Yes | Yes | Yes | Yes |  | Yes | 6 | MID |  | Yes | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 7 | PM |  | Yes | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
3 |  |  | Yes | Yes |  |  | Yes | Yes |  | 8 | AM |  | Yes | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  | Yes | Yes |  | Yes | Yes | Yes |  | 9 | MID |  | Yes | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  | Yes |  |  |  |  |  |  | 10 | PM |  | Yes | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
4 |  |  | Yes |  |  | Yes |  |  |  | 11 | AM |  | Yes | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | Yes | Yes | Yes |  |  |  | Yes | 12 | MID |  | Yes | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  | Yes |  |  |  | No |  |  | 13 | PM |  | Yes | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
5 |  |  | Yes |  |  |  |  |  |  | 14 | AM |  | Yes | 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  | Yes | Yes |  | Yes |  |  | Yes | 15 | MID |  | Yes | 41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  | Yes |  |  |  |  |  |  | 16 | PM |  | Yes | 44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
6 |  |  | Yes |  |  |  |  |  | Yes | 17 | AM |  | Yes | 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  | Yes | Yes | Yes |  | Yes |  | Yes | 18 | MID |  | Yes | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  | Yes |  |  |  |  | Yes | Yes | 19 | PM |  | Yes | 53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
7 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 20 | AM |  | Yes | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  | Yes |  |  |  |  |  |  | 21 | MID |  | Yes | 59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  | Yes |  | No | No | No | No |  | 22 | PM |  | Yes | 62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
8 |  |  | Yes |  |  |  |  |  |  | 23 | AM |  | Yes | 65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  | Yes |  |  |  |  |  |  | 24 | MID |  | Yes | 68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 25 | PM |  | Yes | 71 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
9 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 26 | AM |  | Yes | 74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 27 | MID |  | Yes | 77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 28 | PM |  | Yes | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
10 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 29 | AM |  | Yes | 83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 30 | MID |  | Yes | 86 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 31 | PM |  | Yes | 89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
11 |  |  | Yes |  |  |  |  |  | Yes | 32 | AM |  | Yes | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | Yes | Yes |  | Yes | Yes | Yes |  | 33 | MID |  | Yes | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | Yes |  |  |  |  |  |  | 34 | PM |  | Yes | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
12 |  |  | Yes |  |  | Yes |  |  |  | 35 | AM |  | Yes | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  | Yes | Yes | Yes |  |  |  | Yes | 36 | MID |  | Yes | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  | Yes |  |  |  | No |  |  | 37 | PM |  | Yes | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
13 |  |  | Yes |  |  |  |  |  |  | 38 | AM |  | Yes | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  | Yes | Yes |  | Yes |  |  | Yes | 39 | MID |  | Yes | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  | Yes |  |  |  |  |  |  | 40 | PM |  | Yes | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
14 |  |  | Yes |  |  |  |  |  | Yes | 41 | AM |  | Yes | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | Yes | Yes | Yes |  | Yes |  | Yes | 42 | MID |  | Yes | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  | Yes |  |  |  |  | Yes | Yes | 43 | PM |  | Yes | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
15 |  |  |  | Yes | Yes | Yes | Yes |  |  | 44 | AM |  | Yes | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 45 | MID |  | Yes | 42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 46 | PM |  | Yes | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  | Yes | Yes | Yes | Yes |  |  | 47 | AM |  | Yes | 48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 48 | MID |  | Yes | 51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 49 | PM |  | Yes | 54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
17 |  |  |  |  |  |  |  |  |  | 50 | AM |  | Yes | 57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  | Yes | Yes |  | Yes | Yes | Yes |  | 51 | MID |  | Yes | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  | Yes |  | Yes |  |  |  | Yes | 52 | PM |  | Yes | 63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
18 |  |  |  |  |  |  |  |  |  | 53 | AM |  | Yes | 66 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  | Yes | Yes | Yes |  |  |  | Yes | 54 | MID |  | Yes | 69 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  | Yes |  |  |  | No |  |  | 55 | PM |  | Yes | 72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
19 |  |  |  |  |  |  |  |  |  | 56 | AM |  | Yes | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  | Yes | Yes |  | Yes |  |  | Yes | 57 | MID |  | Yes | 78 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  | Yes |  |  |  |  |  |  | 58 | PM |  | Yes | 81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
20 |  |  | Yes |  |  |  |  |  | Yes | 59 | AM |  | Yes | 84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  | Yes | Yes | Yes |  | Yes |  | Yes | 60 | MID |  | Yes | 87 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  | Yes |  | Yes |  |  | Yes | Yes | 61 | PM |  | Yes | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
21 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 62 | AM |  | Yes | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 63 | MID |  | Yes | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 64 | PM |  | Yes | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
22 |  |  | Yes |  |  |  |  |  |  | 65 | AM |  | Yes | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  | Yes | Yes |  | Yes | Yes | Yes |  | 66 | MID |  | Yes | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  | Yes |  | Yes |  |  |  | Yes | 67 | PM |  | Yes | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
23 |  |  |  |  |  |  |  |  |  | 68 | AM |  | Yes | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  | Yes | Yes | Yes |  |  |  | Yes | 69 | MID |  | Yes | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  | Yes |  |  |  | No |  |  | 70 | PM |  | Yes | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
24 |  |  |  |  |  |  |  |  |  | 71 | AM |  | Yes | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | Yes | Yes |  | Yes |  |  | Yes | 72 | MID |  | Yes | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  | Yes |  |  |  |  |  |  | 73 | PM |  | Yes | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
25 |  |  | Yes |  |  |  |  |  | Yes | 74 | AM |  | Yes | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  | Yes | Yes | Yes |  | Yes |  | Yes | 75 | MID |  | Yes | 43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  | Yes |  | Yes |  |  | Yes | Yes | 76 | PM |  | Yes | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
26 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 77 | AM |  | Yes | 49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 78 | MID |  | Yes | 52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  | Yes | Yes | Yes | Yes | Yes |  |  | 79 | PM |  | Yes | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
27 |  |  | Yes |  |  |  |  |  |  | 80 | AM |  | Yes | 58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  | Yes | Yes |  | Yes | Yes | Yes |  | 81 | MID |  | Yes | 61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  | Yes |  | Yes |  |  |  | Yes | 82 | PM |  | Yes | 64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
28 |  |  | Yes |  |  |  |  |  |  | 83 | AM |  | Yes | 67 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  | Yes | Yes | Yes |  |  |  | Yes | 84 | MID |  | Yes | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  | Yes |  |  |  | No |  |  | 85 | PM |  | Yes | 73 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
29 |  |  | Yes |  |  |  |  |  |  | 86 | AM |  | Yes | 76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  | Yes | Yes |  | Yes |  |  | Yes | 87 | MID |  | Yes | 79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  | Yes |  |  |  |  |  |  | 88 | PM |  | Yes | 82 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
30 |  |  | Yes |  |  |  |  |  | Yes | 89 | AM |  | Yes | 85 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  | Yes | Yes | Yes |  | Yes |  | Yes | 90 | MID |  | Yes | 88 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  | Yes |  | Yes |  |  | Yes | Yes | 91 | PM |  | Yes | 91 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30