Ya terima kamis mas Odong nando,
itu dah yang mau tak tanyakan, di custom filter itu kan pilihannya ada 2 mas,
pertama saya isi contains " panji "anddoes not contains "anom"
mau mengisi wanagiri itu gimana caranya ya..:)maaf masih belum bisa.
nb. kenapa berisi contains, karena datanya masih banyak lagi diluar data yang
saya lampirkan itu.
regardsketut
On Thursday, 11 August 2016, 18:59, "odong nando [email protected]
[belajar-excel]" <[email protected]> wrote:
sudah coba custom filter "does not contain" ketik "anom" and "does not
contain" ketik "wanagiri", klo belum coba dulu...klo masih bermasalah tar pasti
ada master yang kasih jawaban atas kasus ini...
br,
odong nando
Dari: "ketut budiasa [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Kamis, 11 Agustus 2016 12:21
Judul: Re: Bls: [belajar-excel] auto filter multi criteria [1 Attachment]
Terima kasih masukannya mas kid, maaf mungkin data saya kurang, saya
sertakan filenya biar lebih jelas.di kolom alamat disana ada contoh 3 desa,
desa panji, desa panji anom, desa wanagiri ( tetapi ada banjarnya namanya panji
juga )padahal saya pinginnya menampilkan yang desa panji saja, mungkin dengan
key "ds. panji atau desa panji atau ds panji" sementara alamat yang dengan key
panji tetapi ada kata anom maupun wanagiri tidak perlu ditampilkan.
regardsketut
On Tuesday, 9 August 2016, 12:06, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
Hai Yudhi,
Maksud mas Odong itu, kenapa difilter pakai Contain ? Kok gak di clear filter
lalu klik icon filter, hilangkan centang select all, lalu centang item yang
bunyinya 'Panji' doing ?
Kalau Anda pengennya pakai filter yang diketik-ketik, mbok yao jangan pilih
yang contains... artinya contains kan 'yang ada bunyinya' jadi, pastilah panji
antah berantah akan muncul juga
Coba pilih yang equal
Regards,
Kid
2016-08-09 10:40 GMT+07:00 [email protected] [belajar-excel]
<[email protected]>:
Terima kasih replynya om odong nando, yg saya inginkan itu panji saja,
sementara panji yang lainnya tidak perlu ditampilkan.
RegardsKetut
Sent from my iPhone
On 8 Agt 2016, at 17.46, odong nando [email protected] [belajar-excel]
<[email protected] > wrote:
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
#yiv7235010368 #yiv7235010368 -- #yiv7235010368ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7235010368
#yiv7235010368ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7235010368
#yiv7235010368ygrp-mkp #yiv7235010368hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7235010368 #yiv7235010368ygrp-mkp #yiv7235010368ads
{margin-bottom:10px;}#yiv7235010368 #yiv7235010368ygrp-mkp .yiv7235010368ad
{padding:0 0;}#yiv7235010368 #yiv7235010368ygrp-mkp .yiv7235010368ad p
{margin:0;}#yiv7235010368 #yiv7235010368ygrp-mkp .yiv7235010368ad a
{color:#0000ff;text-decoration:none;}#yiv7235010368 #yiv7235010368ygrp-sponsor
#yiv7235010368ygrp-lc {font-family:Arial;}#yiv7235010368
#yiv7235010368ygrp-sponsor #yiv7235010368ygrp-lc #yiv7235010368hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7235010368
#yiv7235010368ygrp-sponsor #yiv7235010368ygrp-lc .yiv7235010368ad
{margin-bottom:10px;padding:0 0;}#yiv7235010368 #yiv7235010368actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7235010368
#yiv7235010368activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7235010368
#yiv7235010368activity span {font-weight:700;}#yiv7235010368
#yiv7235010368activity span:first-child
{text-transform:uppercase;}#yiv7235010368 #yiv7235010368activity span a
{color:#5085b6;text-decoration:none;}#yiv7235010368 #yiv7235010368activity span
span {color:#ff7900;}#yiv7235010368 #yiv7235010368activity span
.yiv7235010368underline {text-decoration:underline;}#yiv7235010368
.yiv7235010368attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7235010368 .yiv7235010368attach div a
{text-decoration:none;}#yiv7235010368 .yiv7235010368attach img
{border:none;padding-right:5px;}#yiv7235010368 .yiv7235010368attach label
{display:block;margin-bottom:5px;}#yiv7235010368 .yiv7235010368attach label a
{text-decoration:none;}#yiv7235010368 blockquote {margin:0 0 0
4px;}#yiv7235010368 .yiv7235010368bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7235010368
.yiv7235010368bold a {text-decoration:none;}#yiv7235010368 dd.yiv7235010368last
p a {font-family:Verdana;font-weight:700;}#yiv7235010368 dd.yiv7235010368last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7235010368
dd.yiv7235010368last p span.yiv7235010368yshortcuts
{margin-right:0;}#yiv7235010368 div.yiv7235010368attach-table div div a
{text-decoration:none;}#yiv7235010368 div.yiv7235010368attach-table
{width:400px;}#yiv7235010368 div.yiv7235010368file-title a, #yiv7235010368
div.yiv7235010368file-title a:active, #yiv7235010368
div.yiv7235010368file-title a:hover, #yiv7235010368 div.yiv7235010368file-title
a:visited {text-decoration:none;}#yiv7235010368 div.yiv7235010368photo-title a,
#yiv7235010368 div.yiv7235010368photo-title a:active, #yiv7235010368
div.yiv7235010368photo-title a:hover, #yiv7235010368
div.yiv7235010368photo-title a:visited {text-decoration:none;}#yiv7235010368
div#yiv7235010368ygrp-mlmsg #yiv7235010368ygrp-msg p a
span.yiv7235010368yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7235010368
.yiv7235010368green {color:#628c2a;}#yiv7235010368 .yiv7235010368MsoNormal
{margin:0 0 0 0;}#yiv7235010368 o {font-size:0;}#yiv7235010368
#yiv7235010368photos div {float:left;width:72px;}#yiv7235010368
#yiv7235010368photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7235010368
#yiv7235010368photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7235010368
#yiv7235010368reco-category {font-size:77%;}#yiv7235010368
#yiv7235010368reco-desc {font-size:77%;}#yiv7235010368 .yiv7235010368replbq
{margin:4px;}#yiv7235010368 #yiv7235010368ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7235010368 #yiv7235010368ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7235010368
#yiv7235010368ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7235010368
#yiv7235010368ygrp-mlmsg select, #yiv7235010368 input, #yiv7235010368 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7235010368
#yiv7235010368ygrp-mlmsg pre, #yiv7235010368 code {font:115%
monospace;}#yiv7235010368 #yiv7235010368ygrp-mlmsg *
{line-height:1.22em;}#yiv7235010368 #yiv7235010368ygrp-mlmsg #yiv7235010368logo
{padding-bottom:10px;}#yiv7235010368 #yiv7235010368ygrp-msg p a
{font-family:Verdana;}#yiv7235010368 #yiv7235010368ygrp-msg
p#yiv7235010368attach-count span {color:#1E66AE;font-weight:700;}#yiv7235010368
#yiv7235010368ygrp-reco #yiv7235010368reco-head
{color:#ff7900;font-weight:700;}#yiv7235010368 #yiv7235010368ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7235010368 #yiv7235010368ygrp-sponsor
#yiv7235010368ov li a {font-size:130%;text-decoration:none;}#yiv7235010368
#yiv7235010368ygrp-sponsor #yiv7235010368ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7235010368
#yiv7235010368ygrp-sponsor #yiv7235010368ov ul {margin:0;padding:0 0 0
8px;}#yiv7235010368 #yiv7235010368ygrp-text
{font-family:Georgia;}#yiv7235010368 #yiv7235010368ygrp-text p {margin:0 0 1em
0;}#yiv7235010368 #yiv7235010368ygrp-text tt {font-size:120%;}#yiv7235010368
#yiv7235010368ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7235010368
