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] To: [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 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] 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 8:37 AM To: [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]] Sent: Sunday, October 19, 2014 12:35 AM To: [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.
