Spreadsheet: 786168d1657022594-generate-names-based-on-multiple-criteria-and-sort-based-on-smallest-largest-value-sample-15-ans-4
Sheet: scenario1

 |  | School 1: | LOVE |  |  |  | School 6: |  |  |  |  | School 11: |  |  |  |  |  | School 16: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Station Code
 |  | School 2: | FAITH |  |  |  | School 7: |  |  |  |  | School 12: |  |  |  |  |  | School 17: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  | School 3: |  |  |  |  | School 8: |  |  |  |  | School 13: |  |  |  |  |  | School 18: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  | School 4: |  |  |  |  | School 9: |  |  |  |  | School 14: |  |  |  |  |  | School 19:
 |  | School 5: |  |  |  |  | School 10: |  |  |  |  | School 15: |  |  |  |  |  | School 20: |  |  |  |  |  |  |  |  |  |  |  | to |  | No |  | 0
 |  | NAMES |  |  |  |  |  |  | Station code is sorted | Emp no. is sorted | NAMES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  | CRITERIA |  |  |  |  |  | 5 | 2617019 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher III | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 19 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None | [NAME] | JULIET M ATAY
 |  | [NAME] | 1 (Fixed) | Sort names based on Employee number from lowest to highest |  |  |  |  | 5 | 4731383 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | School Principal I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | [NAME] | 2 |  |  |  |  |  | 5 | 4732068 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | [NAME] | 3 |  |  |  |  |  | 5 | 5294436 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | Emmy Walker | 4 |  |  |  |  |  | 12 | 4257987 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 12 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | Bea Loon | 5 |  |  |  |  |  | 12 | 5286833 | Emmy Walker |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | [NAME] |  |  |  |  |  |  | 12 | 5293457 | Bea Loon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher III | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | [NAME] |  |  |  |  |  |  | 12 | 9220020 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | [NAME] |  |  |  |  |  |  | 12 | NEW | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  | [NAME] |  |  |  |  |  |  | 12 | NEW | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 18 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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