Maaf Pak Hendrik, untuk urusan makro saya masih belum paham, untuk rumus excel
standart aja masih bingung. :D
Salam
ZulfikarPalopo, Sulsel
Pada Kamis, 12 Maret 2015 11:29, "Hendrik Karnadi [email protected]
[belajar-excel]" <[email protected]> menulis:
Mau pake macro pak?Intinya adalah advance filter, namun pada saat
dilaksanakan sheet yang diselect pertama kali adalah sheet hasil atau sheet
database.
Macronya bisa ditulis atau direkam....
Salam,HK
Sent from Samsung Mobile
-------- Original message --------From: "Zulfikar N [email protected]
[belajar-excel]" Date:12/03/2015 11:08 (GMT+07:00) To:
[email protected] Subject: Bls: [belajar-excel] Rumus filter data
dengan 2 kriteria
Dear Hendrik,
rencananya akan saya buat database (sheet baru) yang rujukannya dari data
aslinya, agar pada saat saya copas data aslinya, nantinya akan terfilter dengan
sendirinya ke sheet database (sheet baru).
Mohon bantuannya.
Pada Kamis, 12 Maret 2015 10:59, "Hendrik Karnadi [email protected]
[belajar-excel]" <[email protected]> menulis:
Pak Zulfikar,Kenapa musti pake rumus pak...Kan bisa langsung, tinggal
pilih itemnya.
Salam,HK
Sent from Samsung Mobile
-------- Original message --------From: "Zulfikar N [email protected]
[belajar-excel]" Date:12/03/2015 10:30 (GMT+07:00) To:
[email protected] Subject: [belajar-excel] Rumus filter data dengan
2 kriteria [1 Attachment]
Dear Excel Master,Saya mohon bantuan rekan-rekan Excel master, bagaimana
rumus untuk filter data dengan dua kriteria. Untuk lebih jelasnya bisa dilihat
pada file terlampir.
Terima kasih sebelumnya.
SalamZulfikarPalopo, Sulsel
#yiv9894052740 #yiv9894052740 -- #yiv9894052740ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9894052740
#yiv9894052740ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9894052740
#yiv9894052740ygrp-mkp #yiv9894052740hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9894052740 #yiv9894052740ygrp-mkp #yiv9894052740ads
{margin-bottom:10px;}#yiv9894052740 #yiv9894052740ygrp-mkp .yiv9894052740ad
{padding:0 0;}#yiv9894052740 #yiv9894052740ygrp-mkp .yiv9894052740ad p
{margin:0;}#yiv9894052740 #yiv9894052740ygrp-mkp .yiv9894052740ad a
{color:#0000ff;text-decoration:none;}#yiv9894052740 #yiv9894052740ygrp-sponsor
#yiv9894052740ygrp-lc {font-family:Arial;}#yiv9894052740
#yiv9894052740ygrp-sponsor #yiv9894052740ygrp-lc #yiv9894052740hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9894052740
#yiv9894052740ygrp-sponsor #yiv9894052740ygrp-lc .yiv9894052740ad
{margin-bottom:10px;padding:0 0;}#yiv9894052740 #yiv9894052740actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9894052740
#yiv9894052740activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9894052740
#yiv9894052740activity span {font-weight:700;}#yiv9894052740
#yiv9894052740activity span:first-child
{text-transform:uppercase;}#yiv9894052740 #yiv9894052740activity span a
{color:#5085b6;text-decoration:none;}#yiv9894052740 #yiv9894052740activity span
span {color:#ff7900;}#yiv9894052740 #yiv9894052740activity span
.yiv9894052740underline {text-decoration:underline;}#yiv9894052740
.yiv9894052740attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9894052740 .yiv9894052740attach div a
{text-decoration:none;}#yiv9894052740 .yiv9894052740attach img
{border:none;padding-right:5px;}#yiv9894052740 .yiv9894052740attach label
{display:block;margin-bottom:5px;}#yiv9894052740 .yiv9894052740attach label a
{text-decoration:none;}#yiv9894052740 blockquote {margin:0 0 0
4px;}#yiv9894052740 .yiv9894052740bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9894052740
.yiv9894052740bold a {text-decoration:none;}#yiv9894052740 dd.yiv9894052740last
p a {font-family:Verdana;font-weight:700;}#yiv9894052740 dd.yiv9894052740last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9894052740
dd.yiv9894052740last p span.yiv9894052740yshortcuts
{margin-right:0;}#yiv9894052740 div.yiv9894052740attach-table div div a
{text-decoration:none;}#yiv9894052740 div.yiv9894052740attach-table
{width:400px;}#yiv9894052740 div.yiv9894052740file-title a, #yiv9894052740
div.yiv9894052740file-title a:active, #yiv9894052740
div.yiv9894052740file-title a:hover, #yiv9894052740 div.yiv9894052740file-title
a:visited {text-decoration:none;}#yiv9894052740 div.yiv9894052740photo-title a,
#yiv9894052740 div.yiv9894052740photo-title a:active, #yiv9894052740
div.yiv9894052740photo-title a:hover, #yiv9894052740
div.yiv9894052740photo-title a:visited {text-decoration:none;}#yiv9894052740
div#yiv9894052740ygrp-mlmsg #yiv9894052740ygrp-msg p a
span.yiv9894052740yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9894052740
.yiv9894052740green {color:#628c2a;}#yiv9894052740 .yiv9894052740MsoNormal
{margin:0 0 0 0;}#yiv9894052740 o {font-size:0;}#yiv9894052740
#yiv9894052740photos div {float:left;width:72px;}#yiv9894052740
#yiv9894052740photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9894052740
#yiv9894052740photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9894052740
#yiv9894052740reco-category {font-size:77%;}#yiv9894052740
#yiv9894052740reco-desc {font-size:77%;}#yiv9894052740 .yiv9894052740replbq
{margin:4px;}#yiv9894052740 #yiv9894052740ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9894052740 #yiv9894052740ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9894052740
#yiv9894052740ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9894052740
#yiv9894052740ygrp-mlmsg select, #yiv9894052740 input, #yiv9894052740 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9894052740
#yiv9894052740ygrp-mlmsg pre, #yiv9894052740 code {font:115%
monospace;}#yiv9894052740 #yiv9894052740ygrp-mlmsg *
{line-height:1.22em;}#yiv9894052740 #yiv9894052740ygrp-mlmsg #yiv9894052740logo
{padding-bottom:10px;}#yiv9894052740 #yiv9894052740ygrp-msg p a
{font-family:Verdana;}#yiv9894052740 #yiv9894052740ygrp-msg
p#yiv9894052740attach-count span {color:#1E66AE;font-weight:700;}#yiv9894052740
#yiv9894052740ygrp-reco #yiv9894052740reco-head
{color:#ff7900;font-weight:700;}#yiv9894052740 #yiv9894052740ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9894052740 #yiv9894052740ygrp-sponsor
#yiv9894052740ov li a {font-size:130%;text-decoration:none;}#yiv9894052740
#yiv9894052740ygrp-sponsor #yiv9894052740ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9894052740
#yiv9894052740ygrp-sponsor #yiv9894052740ov ul {margin:0;padding:0 0 0
8px;}#yiv9894052740 #yiv9894052740ygrp-text
{font-family:Georgia;}#yiv9894052740 #yiv9894052740ygrp-text p {margin:0 0 1em
0;}#yiv9894052740 #yiv9894052740ygrp-text tt {font-size:120%;}#yiv9894052740
#yiv9894052740ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9894052740
