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

 | School 1: | MERCY |  |  |  | School 6: |  |  |  |  | School 11: |  |  |  |  |  | School 16: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Station Code
 | School 2: | FAITH |  |  |  | School 7: |  |  |  |  | School 12: |  |  |  |  |  | School 17: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 | School 3: |  |  |  |  | School 8: |  |  |  |  | School 13: |  |  |  |  |  | School 18:
 | School 4: |  |  |  |  | School 9: |  |  |  |  | School 14: |  |  |  |  |  | School 19:
 | 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
 |  | CRITERIA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | School Principal I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 | [NAME] | 2 | station code of 12 at cell CF3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 | Emmy Walker | 3 | School at "MERCY"at cell C2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 | Bea Loon | 4 | additional School "FAITH" at Cell C3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 12 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 | [NAME] | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher III | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master 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 |  |  |  |  | 11 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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