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
#yiv5310119761 #yiv5310119761 -- #yiv5310119761ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5310119761
#yiv5310119761ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5310119761
#yiv5310119761ygrp-mkp #yiv5310119761hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5310119761 #yiv5310119761ygrp-mkp #yiv5310119761ads
{margin-bottom:10px;}#yiv5310119761 #yiv5310119761ygrp-mkp .yiv5310119761ad
{padding:0 0;}#yiv5310119761 #yiv5310119761ygrp-mkp .yiv5310119761ad p
{margin:0;}#yiv5310119761 #yiv5310119761ygrp-mkp .yiv5310119761ad a
{color:#0000ff;text-decoration:none;}#yiv5310119761 #yiv5310119761ygrp-sponsor
#yiv5310119761ygrp-lc {font-family:Arial;}#yiv5310119761
#yiv5310119761ygrp-sponsor #yiv5310119761ygrp-lc #yiv5310119761hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5310119761
#yiv5310119761ygrp-sponsor #yiv5310119761ygrp-lc .yiv5310119761ad
{margin-bottom:10px;padding:0 0;}#yiv5310119761 #yiv5310119761actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5310119761
#yiv5310119761activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5310119761
#yiv5310119761activity span {font-weight:700;}#yiv5310119761
#yiv5310119761activity span:first-child
{text-transform:uppercase;}#yiv5310119761 #yiv5310119761activity span a
{color:#5085b6;text-decoration:none;}#yiv5310119761 #yiv5310119761activity span
span {color:#ff7900;}#yiv5310119761 #yiv5310119761activity span
.yiv5310119761underline {text-decoration:underline;}#yiv5310119761
.yiv5310119761attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5310119761 .yiv5310119761attach div a
{text-decoration:none;}#yiv5310119761 .yiv5310119761attach img
{border:none;padding-right:5px;}#yiv5310119761 .yiv5310119761attach label
{display:block;margin-bottom:5px;}#yiv5310119761 .yiv5310119761attach label a
{text-decoration:none;}#yiv5310119761 blockquote {margin:0 0 0
4px;}#yiv5310119761 .yiv5310119761bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5310119761
.yiv5310119761bold a {text-decoration:none;}#yiv5310119761 dd.yiv5310119761last
p a {font-family:Verdana;font-weight:700;}#yiv5310119761 dd.yiv5310119761last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5310119761
dd.yiv5310119761last p span.yiv5310119761yshortcuts
{margin-right:0;}#yiv5310119761 div.yiv5310119761attach-table div div a
{text-decoration:none;}#yiv5310119761 div.yiv5310119761attach-table
{width:400px;}#yiv5310119761 div.yiv5310119761file-title a, #yiv5310119761
div.yiv5310119761file-title a:active, #yiv5310119761
div.yiv5310119761file-title a:hover, #yiv5310119761 div.yiv5310119761file-title
a:visited {text-decoration:none;}#yiv5310119761 div.yiv5310119761photo-title a,
#yiv5310119761 div.yiv5310119761photo-title a:active, #yiv5310119761
div.yiv5310119761photo-title a:hover, #yiv5310119761
div.yiv5310119761photo-title a:visited {text-decoration:none;}#yiv5310119761
div#yiv5310119761ygrp-mlmsg #yiv5310119761ygrp-msg p a
span.yiv5310119761yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5310119761
.yiv5310119761green {color:#628c2a;}#yiv5310119761 .yiv5310119761MsoNormal
{margin:0 0 0 0;}#yiv5310119761 o {font-size:0;}#yiv5310119761
#yiv5310119761photos div {float:left;width:72px;}#yiv5310119761
#yiv5310119761photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5310119761
#yiv5310119761photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5310119761
#yiv5310119761reco-category {font-size:77%;}#yiv5310119761
#yiv5310119761reco-desc {font-size:77%;}#yiv5310119761 .yiv5310119761replbq
{margin:4px;}#yiv5310119761 #yiv5310119761ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5310119761 #yiv5310119761ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5310119761
#yiv5310119761ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5310119761
#yiv5310119761ygrp-mlmsg select, #yiv5310119761 input, #yiv5310119761 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5310119761
#yiv5310119761ygrp-mlmsg pre, #yiv5310119761 code {font:115%
monospace;}#yiv5310119761 #yiv5310119761ygrp-mlmsg *
{line-height:1.22em;}#yiv5310119761 #yiv5310119761ygrp-mlmsg #yiv5310119761logo
{padding-bottom:10px;}#yiv5310119761 #yiv5310119761ygrp-msg p a
{font-family:Verdana;}#yiv5310119761 #yiv5310119761ygrp-msg
p#yiv5310119761attach-count span {color:#1E66AE;font-weight:700;}#yiv5310119761
#yiv5310119761ygrp-reco #yiv5310119761reco-head
{color:#ff7900;font-weight:700;}#yiv5310119761 #yiv5310119761ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5310119761 #yiv5310119761ygrp-sponsor
#yiv5310119761ov li a {font-size:130%;text-decoration:none;}#yiv5310119761
#yiv5310119761ygrp-sponsor #yiv5310119761ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5310119761
#yiv5310119761ygrp-sponsor #yiv5310119761ov ul {margin:0;padding:0 0 0
8px;}#yiv5310119761 #yiv5310119761ygrp-text
{font-family:Georgia;}#yiv5310119761 #yiv5310119761ygrp-text p {margin:0 0 1em
0;}#yiv5310119761 #yiv5310119761ygrp-text tt {font-size:120%;}#yiv5310119761
#yiv5310119761ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5310119761
