3 Messages
Digest #3652
Messages
Sat Nov 21, 2015 9:03 am (PST) . Posted by:
"Toby kenzo" tobykenzo
Dear pak Samsudin,
Pertama,buat table matrix pada sheet2 untuk masing2 kategori, kemudian buat patokan data untuk table matrixnya(kalo bisa sesuai dng Satuan Internasional,misal panjang,satuannya meter,tekanan,satuannya Pascal,dll..)
Kedua buat formula Vlookup dgn match,pake Lookup jg bisa, karena ada 3 kategori,maka di buat 3 kondisi dgn formula IF dan IFERROR.
Semoga membantu.
TerimaKasih.
Sent from Yahoo Mail on Android
Pertama,buat table matrix pada sheet2 untuk masing2 kategori, kemudian buat patokan data untuk table matrixnya(kalo bisa sesuai dng Satuan Internasional,
Kedua buat formula Vlookup dgn match,pake Lookup jg bisa, karena ada 3 kategori,maka di buat 3 kondisi dgn formula IF dan IFERROR.
Semoga membantu.
TerimaKasih.
Sent from Yahoo Mail on Android
Sat Nov 21, 2015 6:01 pm (PST) . Posted by:
"Samsudin"
Dear Pak Toby,
Terima kasih atas pencerahannya dan sangat membantu sekali dalam pembuatan template ini.
Hormat saya,
Samsudin
08112810068
Dikirim dari perangkat Samsung E7 saya
-------- Pesan asli --------
Dari: "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Tanggal: 22/11/2015 01:03 (GMT+08:00)
Ke: belajar-excel@yahoogroups.com
Subjek: Re: [belajar-excel] konsversi satuan [1 Attachment]
Dear pak Samsudin,
Pertama,buat table matrix pada sheet2 untuk masing2 kategori, kemudian buat patokan data untuk table matrixnya(kalo bisa sesuai dng Satuan Internasional,misal panjang,satuannya meter,tekanan,satuannya Pascal,dll..)
Kedua buat formula Vlookup dgn match,pake Lookup jg bisa, karena ada 3 kategori,maka di buat 3 kondisi dgn formula IF dan IFERROR.
Semoga membantu.
TerimaKasih.
Sent from Yahoo Mail on Android<http://overview.mail.yahoo.com/mobile/?.src=Android>
________________________________
From: Samsudin samsudin@bayan.com.sg [belajar-excel] <belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: [belajar-excel] konsversi satuan [1 Attachment]
Sent: Sat, Nov 21, 2015 7:51:54 AM
Dear Master Excel,
Saya punya masalah dengan formula untuk buat template satuan panjang, tekanan, dan energy (file terlampir). Bagiamana formulanya untuk bisa secara otomatis jika saya memilih pada cell f2, kemudian saya memilih lagi cell h2, kemudian saya menginput nilai pada cell g2, sehingga saya akan mendapatkan nilai otomatis muncul (berubah-ubah) sesuai pilihan pada cell h4, dimana acuannya ada pada cell b12 :d20.
Sebelumnya saya mengucapkan banyak terima kasih dan sebagai informasi pada kasus ini saya sudah menggunakan formula dari Mba Siti (Alm)_dynamic_dropdownlist.
Terima kasih
Samsudin
----------------------------------------------------------
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.
Terima kasih atas pencerahannya dan sangat membantu sekali dalam pembuatan template ini.
Hormat saya,
Samsudin
08112810068
Dikirim dari perangkat Samsung E7 saya
-------- Pesan asli --------
Dari: "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Tanggal: 22/11/2015 01:03 (GMT+08:00)
Ke: belajar-excel@yahoogroups.com
Subjek: Re: [belajar-excel] konsversi satuan [1 Attachment]
Dear pak Samsudin,
Pertama,buat table matrix pada sheet2 untuk masing2 kategori, kemudian buat patokan data untuk table matrixnya(kalo bisa sesuai dng Satuan Internasional,misal panjang,satuannya meter,tekanan,satuannya Pascal,dll..)
Kedua buat formula Vlookup dgn match,pake Lookup jg bisa, karena ada 3 kategori,maka di buat 3 kondisi dgn formula IF dan IFERROR.
Semoga membantu.
TerimaKasih.
Sent from Yahoo Mail on Android<http://overview.mail.yahoo.com/mobile/?.src=Android>
________________________________
From: Samsudin samsudin@bayan.com.sg [belajar-excel] <belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: [belajar-excel] konsversi satuan [1 Attachment]
Sent: Sat, Nov 21, 2015 7:51:54 AM
Dear Master Excel,
Saya punya masalah dengan formula untuk buat template satuan panjang, tekanan, dan energy (file terlampir). Bagiamana formulanya untuk bisa secara otomatis jika saya memilih pada cell f2, kemudian saya memilih lagi cell h2, kemudian saya menginput nilai pada cell g2, sehingga saya akan mendapatkan nilai otomatis muncul (berubah-ubah) sesuai pilihan pada cell h4, dimana acuannya ada pada cell b12 :d20.
Sebelumnya saya mengucapkan banyak terima kasih dan sebagai informasi pada kasus ini saya sudah menggunakan formula dari Mba Siti (Alm)_dynamic_
Terima kasih
Samsudin
------------
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.
Sat Nov 21, 2015 10:23 pm (PST) . Posted by:
fathianm
Trimakasih atas solusinya Mr. Kid udah sy coba dan sukses tp ketika rumusnya sy copy kesamping kok ga bisa ya hasilnya sama seperti cel dikananya kalo kebawah bisa.
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Tidak ada komentar:
Posting Komentar