langsung aja ga usah ada "panji" nya does not contains "wanagiri"anddoes not contains "anom" br,
odong nando Dari: "ketut budiasa yudix_ke...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> Kepada: belajar-excel@yahoogroups.com Dikirim: Jumat, 12 Agustus 2016 8:30 Judul: Re: Bls: Bls: [belajar-excel] auto filter multi criteria 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 odongna...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> 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 yudix_ke...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> Kepada: belajar-excel@yahoogroups.com 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' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> 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 yudix_ke...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>: 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 odongna...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com > wrote: kenapa tidak langsung pilih "panji" saja dalam bagian filternya, unchecklis "select all" pilih / checklist "panji" saja br, odong nando Dari: "ketut budiasa yudix_ke...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com > Kepada: belajar-excel@yahoogroups.com 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 #yiv9455028437 #yiv9455028437 -- #yiv9455028437ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9455028437 #yiv9455028437ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9455028437 #yiv9455028437ygrp-mkp #yiv9455028437hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9455028437 #yiv9455028437ygrp-mkp #yiv9455028437ads {margin-bottom:10px;}#yiv9455028437 #yiv9455028437ygrp-mkp .yiv9455028437ad {padding:0 0;}#yiv9455028437 #yiv9455028437ygrp-mkp .yiv9455028437ad p {margin:0;}#yiv9455028437 #yiv9455028437ygrp-mkp .yiv9455028437ad a {color:#0000ff;text-decoration:none;}#yiv9455028437 #yiv9455028437ygrp-sponsor #yiv9455028437ygrp-lc {font-family:Arial;}#yiv9455028437 #yiv9455028437ygrp-sponsor #yiv9455028437ygrp-lc #yiv9455028437hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9455028437 #yiv9455028437ygrp-sponsor #yiv9455028437ygrp-lc .yiv9455028437ad {margin-bottom:10px;padding:0 0;}#yiv9455028437 #yiv9455028437actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9455028437 #yiv9455028437activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9455028437 #yiv9455028437activity span {font-weight:700;}#yiv9455028437 #yiv9455028437activity span:first-child {text-transform:uppercase;}#yiv9455028437 #yiv9455028437activity span a {color:#5085b6;text-decoration:none;}#yiv9455028437 #yiv9455028437activity span span {color:#ff7900;}#yiv9455028437 #yiv9455028437activity span .yiv9455028437underline {text-decoration:underline;}#yiv9455028437 .yiv9455028437attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9455028437 .yiv9455028437attach div a {text-decoration:none;}#yiv9455028437 .yiv9455028437attach img {border:none;padding-right:5px;}#yiv9455028437 .yiv9455028437attach label {display:block;margin-bottom:5px;}#yiv9455028437 .yiv9455028437attach label a {text-decoration:none;}#yiv9455028437 blockquote {margin:0 0 0 4px;}#yiv9455028437 .yiv9455028437bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9455028437 .yiv9455028437bold a {text-decoration:none;}#yiv9455028437 dd.yiv9455028437last p a {font-family:Verdana;font-weight:700;}#yiv9455028437 dd.yiv9455028437last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9455028437 dd.yiv9455028437last p span.yiv9455028437yshortcuts {margin-right:0;}#yiv9455028437 div.yiv9455028437attach-table div div a {text-decoration:none;}#yiv9455028437 div.yiv9455028437attach-table {width:400px;}#yiv9455028437 div.yiv9455028437file-title a, #yiv9455028437 div.yiv9455028437file-title a:active, #yiv9455028437 div.yiv9455028437file-title a:hover, #yiv9455028437 div.yiv9455028437file-title a:visited {text-decoration:none;}#yiv9455028437 div.yiv9455028437photo-title a, #yiv9455028437 div.yiv9455028437photo-title a:active, #yiv9455028437 div.yiv9455028437photo-title a:hover, #yiv9455028437 div.yiv9455028437photo-title a:visited {text-decoration:none;}#yiv9455028437 div#yiv9455028437ygrp-mlmsg #yiv9455028437ygrp-msg p a span.yiv9455028437yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9455028437 .yiv9455028437green {color:#628c2a;}#yiv9455028437 .yiv9455028437MsoNormal {margin:0 0 0 0;}#yiv9455028437 o {font-size:0;}#yiv9455028437 #yiv9455028437photos div {float:left;width:72px;}#yiv9455028437 #yiv9455028437photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9455028437 #yiv9455028437photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9455028437 #yiv9455028437reco-category {font-size:77%;}#yiv9455028437 #yiv9455028437reco-desc {font-size:77%;}#yiv9455028437 .yiv9455028437replbq {margin:4px;}#yiv9455028437 #yiv9455028437ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9455028437 #yiv9455028437ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9455028437 #yiv9455028437ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9455028437 #yiv9455028437ygrp-mlmsg select, #yiv9455028437 input, #yiv9455028437 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9455028437 #yiv9455028437ygrp-mlmsg pre, #yiv9455028437 code {font:115% monospace;}#yiv9455028437 #yiv9455028437ygrp-mlmsg * {line-height:1.22em;}#yiv9455028437 #yiv9455028437ygrp-mlmsg #yiv9455028437logo {padding-bottom:10px;}#yiv9455028437 #yiv9455028437ygrp-msg p a {font-family:Verdana;}#yiv9455028437 #yiv9455028437ygrp-msg p#yiv9455028437attach-count span {color:#1E66AE;font-weight:700;}#yiv9455028437 #yiv9455028437ygrp-reco #yiv9455028437reco-head {color:#ff7900;font-weight:700;}#yiv9455028437 #yiv9455028437ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9455028437 #yiv9455028437ygrp-sponsor #yiv9455028437ov li a {font-size:130%;text-decoration:none;}#yiv9455028437 #yiv9455028437ygrp-sponsor #yiv9455028437ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9455028437 #yiv9455028437ygrp-sponsor #yiv9455028437ov ul {margin:0;padding:0 0 0 8px;}#yiv9455028437 #yiv9455028437ygrp-text {font-family:Georgia;}#yiv9455028437 #yiv9455028437ygrp-text p {margin:0 0 1em 0;}#yiv9455028437 #yiv9455028437ygrp-text tt {font-size:120%;}#yiv9455028437 #yiv9455028437ygrp-vital ul li:last-child {border-right:none !important;}#yiv9455028437