Dear Mr. Kid,
Terima kasih banyak atas solusi serta pencerahannya. Saya akan coba
implementasikan.dan terima kasih juga atas share blognya..
Regards,
Teguh
On Tuesday, April 21, 2015 11:10 AM, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Hai Teguh,
Filtering bisa dilakukan dengan array formula filtering seperti coretan yang
ada disini.
File terlampir dengan cara lainnya, termasuk kemungkinan untuk menghilangkan
kolom Total Price dari master data.
Wassalam,
Kid
2015-04-20 14:46 GMT+10:00 teguh indrawanto teguh.indrawa...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
Dear Master Excel,
Bagaimana caranya untuk menarik semua data secara otomatis sesuai data
validation yang kita pilih ?
berikut terlampir penjelasan soalnya.
Mohon bantuannya !
Atas perhatian serta bantuannya diucapkan banyak terima kasih.
Regards,
Teguh
#yiv8994902585 #yiv8994902585 -- #yiv8994902585ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8994902585
#yiv8994902585ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8994902585
#yiv8994902585ygrp-mkp #yiv8994902585hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8994902585 #yiv8994902585ygrp-mkp #yiv8994902585ads
{margin-bottom:10px;}#yiv8994902585 #yiv8994902585ygrp-mkp .yiv8994902585ad
{padding:0 0;}#yiv8994902585 #yiv8994902585ygrp-mkp .yiv8994902585ad p
{margin:0;}#yiv8994902585 #yiv8994902585ygrp-mkp .yiv8994902585ad a
{color:#0000ff;text-decoration:none;}#yiv8994902585 #yiv8994902585ygrp-sponsor
#yiv8994902585ygrp-lc {font-family:Arial;}#yiv8994902585
#yiv8994902585ygrp-sponsor #yiv8994902585ygrp-lc #yiv8994902585hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8994902585
#yiv8994902585ygrp-sponsor #yiv8994902585ygrp-lc .yiv8994902585ad
{margin-bottom:10px;padding:0 0;}#yiv8994902585 #yiv8994902585actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8994902585
#yiv8994902585activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8994902585
#yiv8994902585activity span {font-weight:700;}#yiv8994902585
#yiv8994902585activity span:first-child
{text-transform:uppercase;}#yiv8994902585 #yiv8994902585activity span a
{color:#5085b6;text-decoration:none;}#yiv8994902585 #yiv8994902585activity span
span {color:#ff7900;}#yiv8994902585 #yiv8994902585activity span
.yiv8994902585underline {text-decoration:underline;}#yiv8994902585
.yiv8994902585attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8994902585 .yiv8994902585attach div a
{text-decoration:none;}#yiv8994902585 .yiv8994902585attach img
{border:none;padding-right:5px;}#yiv8994902585 .yiv8994902585attach label
{display:block;margin-bottom:5px;}#yiv8994902585 .yiv8994902585attach label a
{text-decoration:none;}#yiv8994902585 blockquote {margin:0 0 0
4px;}#yiv8994902585 .yiv8994902585bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8994902585
.yiv8994902585bold a {text-decoration:none;}#yiv8994902585 dd.yiv8994902585last
p a {font-family:Verdana;font-weight:700;}#yiv8994902585 dd.yiv8994902585last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8994902585
dd.yiv8994902585last p span.yiv8994902585yshortcuts
{margin-right:0;}#yiv8994902585 div.yiv8994902585attach-table div div a
{text-decoration:none;}#yiv8994902585 div.yiv8994902585attach-table
{width:400px;}#yiv8994902585 div.yiv8994902585file-title a, #yiv8994902585
div.yiv8994902585file-title a:active, #yiv8994902585
div.yiv8994902585file-title a:hover, #yiv8994902585 div.yiv8994902585file-title
a:visited {text-decoration:none;}#yiv8994902585 div.yiv8994902585photo-title a,
#yiv8994902585 div.yiv8994902585photo-title a:active, #yiv8994902585
div.yiv8994902585photo-title a:hover, #yiv8994902585
div.yiv8994902585photo-title a:visited {text-decoration:none;}#yiv8994902585
div#yiv8994902585ygrp-mlmsg #yiv8994902585ygrp-msg p a
span.yiv8994902585yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8994902585
.yiv8994902585green {color:#628c2a;}#yiv8994902585 .yiv8994902585MsoNormal
{margin:0 0 0 0;}#yiv8994902585 o {font-size:0;}#yiv8994902585
#yiv8994902585photos div {float:left;width:72px;}#yiv8994902585
#yiv8994902585photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8994902585
#yiv8994902585photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8994902585
#yiv8994902585reco-category {font-size:77%;}#yiv8994902585
#yiv8994902585reco-desc {font-size:77%;}#yiv8994902585 .yiv8994902585replbq
{margin:4px;}#yiv8994902585 #yiv8994902585ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8994902585 #yiv8994902585ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8994902585
#yiv8994902585ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8994902585
#yiv8994902585ygrp-mlmsg select, #yiv8994902585 input, #yiv8994902585 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8994902585
#yiv8994902585ygrp-mlmsg pre, #yiv8994902585 code {font:115%
monospace;}#yiv8994902585 #yiv8994902585ygrp-mlmsg *
{line-height:1.22em;}#yiv8994902585 #yiv8994902585ygrp-mlmsg #yiv8994902585logo
{padding-bottom:10px;}#yiv8994902585 #yiv8994902585ygrp-msg p a
{font-family:Verdana;}#yiv8994902585 #yiv8994902585ygrp-msg
p#yiv8994902585attach-count span {color:#1E66AE;font-weight:700;}#yiv8994902585
#yiv8994902585ygrp-reco #yiv8994902585reco-head
{color:#ff7900;font-weight:700;}#yiv8994902585 #yiv8994902585ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8994902585 #yiv8994902585ygrp-sponsor
#yiv8994902585ov li a {font-size:130%;text-decoration:none;}#yiv8994902585
#yiv8994902585ygrp-sponsor #yiv8994902585ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8994902585
#yiv8994902585ygrp-sponsor #yiv8994902585ov ul {margin:0;padding:0 0 0
8px;}#yiv8994902585 #yiv8994902585ygrp-text
{font-family:Georgia;}#yiv8994902585 #yiv8994902585ygrp-text p {margin:0 0 1em
0;}#yiv8994902585 #yiv8994902585ygrp-text tt {font-size:120%;}#yiv8994902585
#yiv8994902585ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8994902585
