Dear Pak Agus Suyanto, Saya coba bantu dgn menggunakan kombinasi fungsi if, and, left & right sbb utk dicopy pada cell D3 lalu dicopy kebawah : =IF(AND(LEFT(C3,1)="D",RIGHT(B3,4)="EWS1"),"D1",IF(AND(LEFT(C3,1)="D",RIGHT(B3,4)="EWS2"),"D2",IF(AND(LEFT(C3,2)="FG",RIGHT(B3,4)="EWS1"),"M1",IF(AND(LEFT(C3,2)="FG",RIGHT(B3,4)="EWS2"),"M2",IF(AND(LEFT(C3,2)="FM",RIGHT(B3,4)="EWS1"),"H1",IF(AND(LEFT(C3,2)="FM",RIGHT(B3,4)="EWS2"),"H2",""))))))
*file solusi terlampir Semoga sesuai harapan & bermanfaat.. Best regards, Primas Adexa ________________________________ From: Agus Suyanto <[email protected]> To: [email protected] Sent: Thursday, October 17, 2013 12:08 PM Subject: ]] XL-mania [[ Jenis pekerjaan dan statusnya [1 Attachment] Dear Pakar Excell, Mohon bantuannya untuk kasus jenis pekerjaan dan statusnya berikut ini (file terlampir). Terima kasih atas bantuannya Regards, Agus Suyanto
Solusi - Tabel pekerjaan dan status.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
