Spreadsheet: 785795d1656690900-generate-names-based-on-multiple-criteria-and-sort-based-on-smallest-largest-value-sample-revised
Sheet: scenario2

 | School 1: |  |  |  |  | School 6: |  |  |  |  | School 11: |  |  |  |  |  | School 16: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Station Code
 | School 2: |  |  |  |  | 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
 | [NAME] | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 | Bea Loon | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher I | 0 | 0 | 0 |  | 0 | 0-0-0 | 0 |  |  |  |  |  |  | None |  |  |  |  | 11 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
 | [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