Assalmu’alaikum Wr. Wb. Terima kasih Pak Bagus atas pencerahannya dan untuk soal kedua maksudnya saya adalah jika kita memiliki data (misal code unit) yang sudah kita set, tetapi kadang oleh admin menginputnya tidak sesuai dengan code unit yang sudah di setting tadi, maka bagaimana formulanya supaya data yang diketik oleh admin bisa diubah secara otomatis dengan data yang sudah di setting tadi. (file sheet6)
Walikum Salam Wr. Wb, Samsudin, ST P&M Dept Head [cid:[email protected]] PT. GUNUNGBAYAN PRATAMACOAL (Bayan Group Resources) O: +62 542 875 860 Ext :61519 | M: +62 811 2810 068 | +62 813 6914 7150 | email: [email protected]<mailto:[email protected]> P Save a tree & save energy. Don't print this e-mail unless it's really necessary. Go Green !!! ISO 9001 : 2008| ISO 14001 : 2004 | OHSAS 18001 : 2007 From: [email protected] [mailto:[email protected]] Sent: Monday, October 20, 2014 3:40 PM To: [email protected] Subject: Re: [belajar-excel] Cara mengubah data kolom menjadi baris Wa'alaykum salam warohmatullohi wabarokatuhu. Pak Samsudin; Utk soal no. 1, coba begini: =INDEX($D$3:$AH$12,MATCH($B$14,$B$3:$B$12,0),MATCH(DAY(B15),$D$2:$AH$2,0)) Copas kebawah Utk soal no. 2, misal data mulai A2 =SUBSTITUTE(A2,"-"," ") Copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: Samsudin [email protected] [belajar-excel]<mailto:[email protected]%20[belajar-excel]> To: [email protected]<mailto:[email protected]> Sent: Monday, October 20, 2014 12:32 PM Subject: [belajar-excel] Cara mengubah data kolom menjadi baris [1 Attachment] Assalmu’alaikum Wr. Wb. Mohon pencerahannya : 1. Bagaimana caranya membuat formula untuk mengubah data berbentuk kolom menjadi baris atau sebaliknya. 2. Bagaimana caranya membuat formula agar salah kolom (misal code unit) menjadi sesuai dengan kolom yang dikehendaki, misal Tertulis LV-TRT-60 tetapi yang kita kehendaki LV TRT 60 : DATA TERINPUT TULISAN YG DIKEHENDAKI LV-TRT-66 LV TRT 60 PUL200-50 PUL200 50 PUL200-51 PUL200 51 PC200-02 PC200 02 HM-07 ADT HM400 07 HM-08 ADT HM400 07 BD85-04 BD85 04 TJ-01 JHONDEER TJ 01 EXC45-19 EXH45 19 MG705A MG705 01 Walikum Salam Wr. Wb, Samsudin, ST P&M Dept Head [cid:[email protected]] PT. GUNUNGBAYAN PRATAMACOAL (Bayan Group Resources) O: +62 542 875 860 Ext :61519 | M: +62 811 2810 068 | +62 813 6914 7150 | email: [email protected]<mailto:[email protected]> P Save a tree & save energy. Don't print this e-mail unless it's really necessary. Go Green !!! ISO 9001 : 2008| ISO 14001 : 2004 | OHSAS 18001 : 2007 From: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Monday, October 20, 2014 8:37 AM To: [email protected]<mailto:[email protected]> Subject: RE: [belajar-excel] IF banyak kondisi dan bertingkat Assallamualaikum wr.wb, Coba rumus ini, =IF(AND(F2="",G2=""),"Not OK",IF(G2<>"","OK",IF(F2<>"","Kolom G harus diisi","Not OK"))) Semoga sesuai keinginan. Suyono From: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Sunday, October 19, 2014 12:35 AM To: [email protected]<mailto:[email protected]> Subject: [belajar-excel] IF banyak kondisi dan bertingkat [1 Attachment] Assallamualaikum wr.wb, Master Excell, saya memiliki data, menggunakan rumus if. tetapi saya mempunyai kendala. pada kolom F setiap cell nya saya beri data validation, pada saat saya pilih data validation di kolom F muncul keterangan di kolom I yaitu "Kolom G Harus di Isi" dan pada kolom G saya juga beri data validation, pada saat saya pilih data validation di kolom G muncul keterangan di kolom I Juga dengan keterangan jika kolom G dipilih maka keterangannya "OK" jika Tidak maka "Not OK. saya menggunakan rumus If dan if bertingkat, tetapi masih error... mohon diberi petunjuknya ya master Excell Wassalam, Kausar --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed in this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy. --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed in this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy.
DATA HM_Rev.20-10-2014.xlsx
Description: DATA HM_Rev.20-10-2014.xlsx
