Spreadsheet: 814050d1674129310-generate-names-based-on-multiple-criteria-and-sort-based-on-smallest-largest-value-sample-gk-v1-
Sheet: scenario5

 |  |  |  |  |  |  |  |  | School 1: | MERCY |  |  |  | School 6: |  |  |  |  | School 11: |  |  |  |  |  | School 16: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Station Code
 |  |  |  |  |  |  |  | Pin at the TOP | School 2: | FAITH |  |  |  | School 7: |  |  |  |  | School 12: |  |  |  |  |  | School 17: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | 95 | School 3: |  |  |  |  | School 8: |  |  |  |  | School 13: |  |  |  |  |  | School 18: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | School 4: |  |  |  |  | School 9: |  |  |  |  | School 14: |  |  |  |  |  | School 19: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  | School 5: |  |  |  |  | School 10: |  |  |  |  | School 15: |  |  |  |  |  | School 20: |  |  |  |  |  |  |  |  |  |  |  | to |  | No |  | 0
 |  |  |  |  |  |  |  |  | NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMARKS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Leave |  | total Min+Hr | Min | Hr | Sick leave only | Count sick w/0 pay |  | Count w/pay | SL | VL | PL | FL | Solo-PL | Maternity | CAUSE | tardy |  | Undertime |  | basic | Step |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  | 4774702 | FAITH | [NAME] |  |  |  | [NAME] | CRITERIA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher III | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 19 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None | [NAME] | JULIET M ATAY
 |  | 12 | 4256020 | MERCY | [NAME] |  |  |  | Brooklyn Hobbs | 1 (Fixed) | Sort names based on Employee number from lowest to highest with the station codes assign in range CF3:CG6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | School Principal I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | 12 | 4257987 | FAITH | [NAME] |  |  |  | [NAME] | 2 | Sort names with the School name listed from School 1 to School 20 with a station codes in range CF3:CG6 Only (Filter School Name+Station Code) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | 12 | 4770982 | MERCY | [NAME] |  |  |  | [NAME] | 3 | Always pin on Top  the names with the station code set in cell A4, followed by the conditions in criteria 1 and 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | 12 | 5286833 | FAITH | Emmy Walker |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 12 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | 12 | 5293457 | FAITH | Bea Loon |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | 5 | 5294436 | FAITH | [NAME] |  |  |  | Emmy Walker |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher III | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | 12 | 5296754 | MERCY | [NAME] |  |  |  | Bea Loon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | 12 | 5296792 | MERCY | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | 5 | 6412708 | MERCY | Brooklyn Hobbs |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 18 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | 12 | NEW | FAITH | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher III | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 19 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher III | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 18 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher II | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 19 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher II | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 18 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None