kenapa tidak langsung pilih "panji" saja dalam bagian filternya, unchecklis
"select all" pilih / checklist "panji" saja br,
odong nando
Dari: "ketut budiasa [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Senin, 8 Agustus 2016 11:15
Judul: [belajar-excel] auto filter multi criteria
Dear be Excelers, minta tolong saya ada beberapa kolom data.
Saya pingin menampilkan data dengan auto filter, "contains" dan juga "does not
contains".
contohnya ada kolom alamat-panji-panji anom-panji wanagiri-banjar panji.-panji
xxx-panji yyy
saya pinginnya menfilter yang ada kata panji saja, sementara panji yang berisi
anom, wanagiri, banjar, xxx maupun yyy tidak usah ditampilkan.kira-kira bisa
dibantu.
maaf jika kurang bisa menjelaskan, tapi mudah2an bisa dimengerti maksudnya.
regardsketut
#yiv7835707510 #yiv7835707510 -- #yiv7835707510ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7835707510
#yiv7835707510ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7835707510
#yiv7835707510ygrp-mkp #yiv7835707510hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7835707510 #yiv7835707510ygrp-mkp #yiv7835707510ads
{margin-bottom:10px;}#yiv7835707510 #yiv7835707510ygrp-mkp .yiv7835707510ad
{padding:0 0;}#yiv7835707510 #yiv7835707510ygrp-mkp .yiv7835707510ad p
{margin:0;}#yiv7835707510 #yiv7835707510ygrp-mkp .yiv7835707510ad a
{color:#0000ff;text-decoration:none;}#yiv7835707510 #yiv7835707510ygrp-sponsor
#yiv7835707510ygrp-lc {font-family:Arial;}#yiv7835707510
#yiv7835707510ygrp-sponsor #yiv7835707510ygrp-lc #yiv7835707510hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7835707510
#yiv7835707510ygrp-sponsor #yiv7835707510ygrp-lc .yiv7835707510ad
{margin-bottom:10px;padding:0 0;}#yiv7835707510 #yiv7835707510actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7835707510
#yiv7835707510activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7835707510
#yiv7835707510activity span {font-weight:700;}#yiv7835707510
#yiv7835707510activity span:first-child
{text-transform:uppercase;}#yiv7835707510 #yiv7835707510activity span a
{color:#5085b6;text-decoration:none;}#yiv7835707510 #yiv7835707510activity span
span {color:#ff7900;}#yiv7835707510 #yiv7835707510activity span
.yiv7835707510underline {text-decoration:underline;}#yiv7835707510
.yiv7835707510attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7835707510 .yiv7835707510attach div a
{text-decoration:none;}#yiv7835707510 .yiv7835707510attach img
{border:none;padding-right:5px;}#yiv7835707510 .yiv7835707510attach label
{display:block;margin-bottom:5px;}#yiv7835707510 .yiv7835707510attach label a
{text-decoration:none;}#yiv7835707510 blockquote {margin:0 0 0
4px;}#yiv7835707510 .yiv7835707510bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7835707510
.yiv7835707510bold a {text-decoration:none;}#yiv7835707510 dd.yiv7835707510last
p a {font-family:Verdana;font-weight:700;}#yiv7835707510 dd.yiv7835707510last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7835707510
dd.yiv7835707510last p span.yiv7835707510yshortcuts
{margin-right:0;}#yiv7835707510 div.yiv7835707510attach-table div div a
{text-decoration:none;}#yiv7835707510 div.yiv7835707510attach-table
{width:400px;}#yiv7835707510 div.yiv7835707510file-title a, #yiv7835707510
div.yiv7835707510file-title a:active, #yiv7835707510
div.yiv7835707510file-title a:hover, #yiv7835707510 div.yiv7835707510file-title
a:visited {text-decoration:none;}#yiv7835707510 div.yiv7835707510photo-title a,
#yiv7835707510 div.yiv7835707510photo-title a:active, #yiv7835707510
div.yiv7835707510photo-title a:hover, #yiv7835707510
div.yiv7835707510photo-title a:visited {text-decoration:none;}#yiv7835707510
div#yiv7835707510ygrp-mlmsg #yiv7835707510ygrp-msg p a
span.yiv7835707510yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7835707510
.yiv7835707510green {color:#628c2a;}#yiv7835707510 .yiv7835707510MsoNormal
{margin:0 0 0 0;}#yiv7835707510 o {font-size:0;}#yiv7835707510
#yiv7835707510photos div {float:left;width:72px;}#yiv7835707510
#yiv7835707510photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7835707510
#yiv7835707510photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7835707510
#yiv7835707510reco-category {font-size:77%;}#yiv7835707510
#yiv7835707510reco-desc {font-size:77%;}#yiv7835707510 .yiv7835707510replbq
{margin:4px;}#yiv7835707510 #yiv7835707510ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7835707510 #yiv7835707510ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7835707510
#yiv7835707510ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7835707510
#yiv7835707510ygrp-mlmsg select, #yiv7835707510 input, #yiv7835707510 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7835707510
#yiv7835707510ygrp-mlmsg pre, #yiv7835707510 code {font:115%
monospace;}#yiv7835707510 #yiv7835707510ygrp-mlmsg *
{line-height:1.22em;}#yiv7835707510 #yiv7835707510ygrp-mlmsg #yiv7835707510logo
{padding-bottom:10px;}#yiv7835707510 #yiv7835707510ygrp-msg p a
{font-family:Verdana;}#yiv7835707510 #yiv7835707510ygrp-msg
p#yiv7835707510attach-count span {color:#1E66AE;font-weight:700;}#yiv7835707510
#yiv7835707510ygrp-reco #yiv7835707510reco-head
{color:#ff7900;font-weight:700;}#yiv7835707510 #yiv7835707510ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7835707510 #yiv7835707510ygrp-sponsor
#yiv7835707510ov li a {font-size:130%;text-decoration:none;}#yiv7835707510
#yiv7835707510ygrp-sponsor #yiv7835707510ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7835707510
#yiv7835707510ygrp-sponsor #yiv7835707510ov ul {margin:0;padding:0 0 0
8px;}#yiv7835707510 #yiv7835707510ygrp-text
{font-family:Georgia;}#yiv7835707510 #yiv7835707510ygrp-text p {margin:0 0 1em
0;}#yiv7835707510 #yiv7835707510ygrp-text tt {font-size:120%;}#yiv7835707510
#yiv7835707510ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7835707510
