Spreadsheet: 144678d1331091859-excluding-certain-value-from-max-function-that-has-multiple-separated-values-uniform-issuance-analysis
Sheet: Database Example

NO | EMP. NO | NAME |  |  |  |  | SEX | JOB RANK | JOB TITLE | DEPARTMENT | SECTION | DATE JOINNED | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TROUSER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHOES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMARK | COMPANY NAME | Shirt |  |  |  |  |  |  |  | Trouser |  |  |  |  |  |  |  | Shoes
 |  |  |  |  |  |  |  |  |  |  |  |  | Latest Issuance |  |  |  | 1st Issuance |  |  |  | 2nd Issuance |  |  |  | 3rd Issuance |  |  |  | 4th Issuance |  |  |  | 5th Issuance |  |  |  | 6th Issuance |  |  |  |  |  |  |  | 1st Issuance |  |  |  | 2nd Issuance |  |  |  |  | 3rd Issuance |  |  | 4th Issuance |  |  |  | 5th Issuance |  |  |  | 6th Issuance |  |  |  |  |  |  |  | 1st Issuance |  |  |  | 2nd Issuance |  |  |  | 3rd Issuance |  |  |  | 4th Issuance |  |  |  | 5th Issuance |  |  |  | 6th Issuance |  |  |  |  |  | 7th Issuance |  |  |  | 8th Issuance |  |  |  | 7th Issuance |  |  |  | 8th Issuance |  |  |  | 7th Issuance |  |  |  | 8th Issuance
 |  |  |  |  |  |  |  |  |  |  |  |  | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY |  |  | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY
1 | 2 | TAN YAP JEE | 2 | 1 | TAN YAP JEE | 1 | M | A0 | SENIOR MANAGER | PURCHASING | - | 1989-09-15 00:00:00 | 2011-06-24 00:00:00 | L/B - (S) | XL | 1 | 2007-07-30 00:00:00 | L/B - (S) | XL | 1 | 2010-03-25 00:00:00 | L/B - (S) | XL | 1 | 2010-07-19 00:00:00 | L/B - (S) | XL | 1 | 2010-08-02 00:00:00 | L/B - (S) | XL | 1 | 2011-06-24 00:00:00 | L/B - (S) | XL | 1 |  |  |  |  | 2011-06-24 00:00:00 | PROD | XL | 1 | 2007-07-30 00:00:00 | PROD | XL | 1 | 2010-08-02 00:00:00 | PROD | XL | 1 | 2011-06-24 00:00:00 | PROD | XL | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 2007-07-30 00:00:00 | SAFETY | 8 | 1 | 2007-07-30 00:00:00 | SAFETY | 8 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.25.3.2010 - change due to colour faded 2.19.7.2010 - Change due to colour faded,3.02 Aug 10 Auto Issued(Trousers Pending-XL)-Given., 4.24/6/2011 - Auto Issued
2 | 19 | MASNIDA BINTI MOHD DIN | 19 | 1 | MASNIDA BINTI MOHD DIN | 1 | F | B1 | ASSISTANT OFFICER(2) | PRODUCTION PLANNING & CONTROL | PLANNING & COORDINATING | 1990-02-20 00:00:00 | 2011-06-24 00:00:00 | MATERNITY | L | 1 | 2007-07-25 00:00:00 | L/B - (L) | M | 1 | 2010-08-02 00:00:00 | L/B - (L) | L | 1 | 2011-06-24 00:00:00 | MATERNITY | L | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-24 00:00:00 | MATERNITY | 2XL | 1 | 2007-07-25 00:00:00 | OFFICE | XL | 1 | 2009-04-09 00:00:00 | OFFICE | XL | 1 | 2010-08-02 00:00:00 | OFFICE | 2XL | 1 | 2011-06-24 00:00:00 | MATERNITY | 2XL | 1 |  |  |  |  |  |  |  |  | 2011-03-11 00:00:00 | NORMAL | 7 | 1 | 2007-07-25 00:00:00 | NORMAL | 6 | 1 | 2009-04-09 00:00:00 | NORMAL | 7 | 1 | 2010-05-18 00:00:00 | NORMAL | 7 | 1 | 2011-03-11 00:00:00 | NORMAL | 7 | 1 |  |  |  |  |  |  |  |  | 1.18/5/2010 - Change normal shoes due to spoilt, 2.02 Aug 10 Auto Issued., 3.11/3/2011 - Change new canvas shoes due to spoilt., 4.24/6/2011 - Auto Issued