{"id":4863,"date":"2023-07-07T02:54:00","date_gmt":"2023-07-07T02:54:00","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/"},"modified":"2023-07-07T02:54:00","modified_gmt":"2023-07-07T02:54:00","slug":"filter-otomatis-vba-tidak-sama-dengan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/","title":{"rendered":"Vba: cara menggunakan &quot;berbeda dari&quot; di autofilter"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan simbol <strong>&lt;&gt;<\/strong> untuk mewakili &#8220;tidak sama dengan&#8221; dalam filter otomatis di VBA.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut adalah cara umum untuk melakukan hal ini dalam praktik:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubFilterNotEqualTo<\/span> ()\n\nRange(\" <span style=\"color: #ff0000;\">A1:C11<\/span> \").AutoFilter Field:=2, Criteria1:=\" <span style=\"color: #ff0000;\">&lt;&gt;Center<\/span> \"\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan memfilter semua baris dalam rentang <strong>A1:C11<\/strong> di mana nilai kolom kedua tidak sama dengan &#8220;Tengah&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Gunakan \u201cBerbeda Dari\u201d di Filter Otomatis di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37981 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autom1.png\" alt=\"\" width=\"460\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin memfilter kumpulan data untuk hanya menampilkan baris yang nilainya di kolom <strong>Posisi<\/strong> tidak sama dengan &#8220;Tengah&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubFilterNotEqualTo<\/span> ()\n\nRange(\" <span style=\"color: #ff0000;\">A1:C11<\/span> \").AutoFilter Field:=2, Criteria1:=\" <span style=\"color: #ff0000;\">&lt;&gt;Center<\/span> \"\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37988 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/n\u00b01.png\" alt=\"\" width=\"510\" height=\"433\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kumpulan data telah difilter untuk hanya menampilkan baris yang nilainya di kolom <strong>Posisi<\/strong> tidak sama dengan &#8220;Pusat&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat memfilter baris yang nilai kolom <strong>Posisinya<\/strong> tidak sama dengan lebih dari satu nilai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda bisa membuat makro berikut untuk memfilter himpunan data agar hanya menampilkan baris yang nilainya di kolom <strong>Posisi<\/strong> tidak sama dengan &#8220;Tengah&#8221; <em>atau<\/em> &#8220;Penjaga&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubFilterNotEqualTo<\/span> ()\n\nRange(\" <span style=\"color: #ff0000;\">A1:C11<\/span> \").AutoFilter Field:=2, Criteria1:=\" <span style=\"color: #ff0000;\">&lt;&gt;Center<\/span> \", Criteria2:=\" <span style=\"color: #ff0000;\">&lt;&gt;Guard<\/span> \"\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37989 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/n\u00b02.png\" alt=\"\" width=\"497\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Saya perhatikan bahwa kumpulan data difilter untuk hanya menampilkan baris yang nilainya di kolom <b>Posisi<\/b> tidak sama dengan &#8220;Tengah&#8221; <em>atau<\/em> &#8220;Penjaga&#8221;:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode VBA <strong>AutoFilter<\/strong> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.range.autofilter\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/\">VBA: Cara menggunakan autofilter dengan banyak kriteria<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-filter-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara memfilter tabel pivot<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/filter-bening-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghapus filter<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan simbol &lt;&gt; untuk mewakili &#8220;tidak sama dengan&#8221; dalam filter otomatis di VBA. Berikut adalah cara umum untuk melakukan hal ini dalam praktik: SubFilterNotEqualTo () Range(&#8221; A1:C11 &#8220;).AutoFilter Field:=2, Criteria1:=&#8221; &lt;&gt;Center &#8221; End Sub Makro khusus ini akan memfilter semua baris dalam rentang A1:C11 di mana nilai kolom kedua tidak sama dengan &#8220;Tengah&#8221;. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: Cara menggunakan \u201cBerbeda dari\u201d di autofilter \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan &quot;tidak sama&quot; dalam autofilter di VBA, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menggunakan \u201cBerbeda dari\u201d di autofilter \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan &quot;tidak sama&quot; dalam autofilter di VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T02:54:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autom1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/\",\"name\":\"VBA: Cara menggunakan \u201cBerbeda dari\u201d di autofilter \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T02:54:00+00:00\",\"dateModified\":\"2023-07-07T02:54:00+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan &quot;tidak sama&quot; dalam autofilter di VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menggunakan &quot;berbeda dari&quot; di autofilter\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA: Cara menggunakan \u201cBerbeda dari\u201d di autofilter \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan &quot;tidak sama&quot; dalam autofilter di VBA, dengan sebuah contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menggunakan \u201cBerbeda dari\u201d di autofilter \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan &quot;tidak sama&quot; dalam autofilter di VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/","og_site_name":"Statorials","article_published_time":"2023-07-07T02:54:00+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/autom1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/","url":"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/","name":"VBA: Cara menggunakan \u201cBerbeda dari\u201d di autofilter \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T02:54:00+00:00","dateModified":"2023-07-07T02:54:00+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan &quot;tidak sama&quot; dalam autofilter di VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-otomatis-vba-tidak-sama-dengan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menggunakan &quot;berbeda dari&quot; di autofilter"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4863"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4863"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4863\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}