本帖最后由 bella_yang 于 2014-7-22 17:27 编辑
求不引用工作表中單元格,用公式得出C列的結果。
分成以下三类
1、Direct Labour
Department | Grade | Sewing | Worker | Cutting | Worker | Moulding | Worker | Packing | Worker |
2、Supporting Staff
Department | Grade | MQC | Worker,S1,S2,S3,S4,M1,M2,M3 | Warehouse | Worker,S1,S2,S3,S4,M1,M2,M3 | Finance | Worker,S1,S2,S3,S4,M1,M2,M3 | HRA | Worker,S1,S2,S3,S4,M1,M2,M3 | Compliance | Worker,S1,S2,S3,S4,M1,M2,M3 | IE | Worker,S1,S2,S3,S4,M1,M2,M3 |
3、Indirect Labour
Department | Grade | Sewing | S1,S2,S3,S4,M1,M2,M3 | Cutting | S1,S2,S3,S4,M1,M2,M4 | Moulding | S1,S2,S3,S4,M1,M2,M5 | Packing | S1,S2,S3,S4,M1,M2,M6 | Planning | Worker,S1,S2,S3,S4,M1,M2,M3 | Technical | Worker,S1,S2,S3,S4,M1,M2,M4 | QA/QC | Worker,S1,S2,S3,S4,M1,M2,M5 | Maintenance | Worker,S1,S2,S3,S4,M1,M2,M6 |
|