Dear Master Lukman, saya tidak familier dengan VB dan lebih prefer Formula biasa, namun tidak ada salah nya untuk mulai belajar sesuatu yang baru :)berikut saya lampirkan ilustrasi data sumber dan data Hasil, Data Sumber dan Hasil berada pada Workbook yang sama dan pada Sheet yang berbeda. Mohon Pencerahan nya Antonius Teguh PrasetyaInternal Audit08113595741087856491360
Pada Minggu, 12 Maret 2017 21:51, "lkm jktind lkmjkt...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Pak Antonius. Apakah boleh di selesaikan VB ? untuk mengisi semua data yg ada di F3:H11 Bila boleh : tolong beritau hasil nya mau di letakan dimana atau sheet apa atau workbook yg sama ? adapun sumber data nya ada sheet apa dengan row, columns berapa ? salam Lukman 2017-03-11 8:55 GMT+07:00 ANTONIUS TEGUH PRASETYA qse...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>: Dear Para Master Excel, Mohon Bantuan untuk membuat Formula yang dapat menampilkan List data yang sesuai dengan beberapa Kriteria. File Contoh dan Hasil yg di inginkan terlampir. Pertanyaan ini sudah pernah saya emailkan sebelum nya, namun hari ini saya cari dalam Sent/Inbox email saya sudah tidak ada, maka saya email ulang. Mohon bantuan nya. Terima Kasih Best Regards Antonius Teguh PrasetyaInternal Audit08113595741087856491360 #yiv4866440431 -- #yiv4866440431ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4866440431 #yiv4866440431ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4866440431 #yiv4866440431ygrp-mkp #yiv4866440431hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4866440431 #yiv4866440431ygrp-mkp #yiv4866440431ads {margin-bottom:10px;}#yiv4866440431 #yiv4866440431ygrp-mkp .yiv4866440431ad {padding:0 0;}#yiv4866440431 #yiv4866440431ygrp-mkp .yiv4866440431ad p {margin:0;}#yiv4866440431 #yiv4866440431ygrp-mkp .yiv4866440431ad a {color:#0000ff;text-decoration:none;}#yiv4866440431 #yiv4866440431ygrp-sponsor #yiv4866440431ygrp-lc {font-family:Arial;}#yiv4866440431 #yiv4866440431ygrp-sponsor #yiv4866440431ygrp-lc #yiv4866440431hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4866440431 #yiv4866440431ygrp-sponsor #yiv4866440431ygrp-lc .yiv4866440431ad {margin-bottom:10px;padding:0 0;}#yiv4866440431 #yiv4866440431actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4866440431 #yiv4866440431activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4866440431 #yiv4866440431activity span {font-weight:700;}#yiv4866440431 #yiv4866440431activity span:first-child {text-transform:uppercase;}#yiv4866440431 #yiv4866440431activity span a {color:#5085b6;text-decoration:none;}#yiv4866440431 #yiv4866440431activity span span {color:#ff7900;}#yiv4866440431 #yiv4866440431activity span .yiv4866440431underline {text-decoration:underline;}#yiv4866440431 .yiv4866440431attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4866440431 .yiv4866440431attach div a {text-decoration:none;}#yiv4866440431 .yiv4866440431attach img {border:none;padding-right:5px;}#yiv4866440431 .yiv4866440431attach label {display:block;margin-bottom:5px;}#yiv4866440431 .yiv4866440431attach label a {text-decoration:none;}#yiv4866440431 blockquote {margin:0 0 0 4px;}#yiv4866440431 .yiv4866440431bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4866440431 .yiv4866440431bold a {text-decoration:none;}#yiv4866440431 dd.yiv4866440431last p a {font-family:Verdana;font-weight:700;}#yiv4866440431 dd.yiv4866440431last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4866440431 dd.yiv4866440431last p span.yiv4866440431yshortcuts {margin-right:0;}#yiv4866440431 div.yiv4866440431attach-table div div a {text-decoration:none;}#yiv4866440431 div.yiv4866440431attach-table {width:400px;}#yiv4866440431 div.yiv4866440431file-title a, #yiv4866440431 div.yiv4866440431file-title a:active, #yiv4866440431 div.yiv4866440431file-title a:hover, #yiv4866440431 div.yiv4866440431file-title a:visited {text-decoration:none;}#yiv4866440431 div.yiv4866440431photo-title a, #yiv4866440431 div.yiv4866440431photo-title a:active, #yiv4866440431 div.yiv4866440431photo-title a:hover, #yiv4866440431 div.yiv4866440431photo-title a:visited {text-decoration:none;}#yiv4866440431 div#yiv4866440431ygrp-mlmsg #yiv4866440431ygrp-msg p a span.yiv4866440431yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4866440431 .yiv4866440431green {color:#628c2a;}#yiv4866440431 .yiv4866440431MsoNormal {margin:0 0 0 0;}#yiv4866440431 o {font-size:0;}#yiv4866440431 #yiv4866440431photos div {float:left;width:72px;}#yiv4866440431 #yiv4866440431photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4866440431 #yiv4866440431photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4866440431 #yiv4866440431reco-category {font-size:77%;}#yiv4866440431 #yiv4866440431reco-desc {font-size:77%;}#yiv4866440431 .yiv4866440431replbq {margin:4px;}#yiv4866440431 #yiv4866440431ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4866440431 #yiv4866440431ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4866440431 #yiv4866440431ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4866440431 #yiv4866440431ygrp-mlmsg select, #yiv4866440431 input, #yiv4866440431 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4866440431 #yiv4866440431ygrp-mlmsg pre, #yiv4866440431 code {font:115% monospace;}#yiv4866440431 #yiv4866440431ygrp-mlmsg * {line-height:1.22em;}#yiv4866440431 #yiv4866440431ygrp-mlmsg #yiv4866440431logo {padding-bottom:10px;}#yiv4866440431 #yiv4866440431ygrp-msg p a {font-family:Verdana;}#yiv4866440431 #yiv4866440431ygrp-msg p#yiv4866440431attach-count span {color:#1E66AE;font-weight:700;}#yiv4866440431 #yiv4866440431ygrp-reco #yiv4866440431reco-head {color:#ff7900;font-weight:700;}#yiv4866440431 #yiv4866440431ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4866440431 #yiv4866440431ygrp-sponsor #yiv4866440431ov li a {font-size:130%;text-decoration:none;}#yiv4866440431 #yiv4866440431ygrp-sponsor #yiv4866440431ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4866440431 #yiv4866440431ygrp-sponsor #yiv4866440431ov ul {margin:0;padding:0 0 0 8px;}#yiv4866440431 #yiv4866440431ygrp-text {font-family:Georgia;}#yiv4866440431 #yiv4866440431ygrp-text p {margin:0 0 1em 0;}#yiv4866440431 #yiv4866440431ygrp-text tt {font-size:120%;}#yiv4866440431 #yiv4866440431ygrp-vital ul li:last-child {border-right:none !important;}#yiv4866440431
Contoh data II.xlsx
Description: MS-Excel 2007 spreadsheet