{"id":4862,"date":"2023-07-07T02:58:19","date_gmt":"2023-07-07T02:58:19","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/"},"modified":"2023-07-07T02:58:19","modified_gmt":"2023-07-07T02:58:19","slug":"vba-autofilter-beberapa-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/","title":{"rendered":"Vba: cara menggunakan autofilter dengan banyak kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk menggunakan <strong>Filter Otomatis<\/strong> di VBA dengan beberapa kriteria:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gunakan Filter Otomatis dengan Banyak Kriteria dalam Satu Kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FilterMultipleCriteria()\n\n<span style=\"color: #0000ff;\">With<\/span> Range(\" <span style=\"color: #ff0000;\">A1:C11<\/span> \")\n    .AutoFilter Field:=1, Criteria1:=Array(\" <span style=\"color: #ff0000;\">A<\/span> \", \" <span style=\"color: #ff0000;\">C<\/span> \"), Operator:=xlFilterValues\n<span style=\"color: #0000ff;\">End With<\/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 pertama sama dengan &#8220;A&#8221; atau &#8220;C&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gunakan Filter Otomatis dengan Banyak Kriteria di Beberapa Kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FilterMultipleCriteria()\n\n<span style=\"color: #0000ff;\">With<\/span> Range(\" <span style=\"color: #ff0000;\">A1:C11<\/span> \")\n    .AutoFilter Field:=1, Criteria1:=\" <span style=\"color: #ff0000;\">A<\/span> \"\n    .AutoFilter Field:=2, Criteria1:=\" <span style=\"color: #ff0000;\">Guard<\/span> \"\n<span style=\"color: #0000ff;\">End With<\/span>\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan memfilter rentang <strong>A1:C11<\/strong> untuk hanya menampilkan baris dengan kolom pertama sama dengan &#8220;A&#8221; dan kolom kedua sama dengan &#8220;Penjaga&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan masing-masing metode ini dalam praktik dengan kumpulan data berikut di Excel:<\/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<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Gunakan Filter Otomatis dengan Beberapa Kriteria dalam Satu Kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin memfilter kumpulan data untuk hanya menampilkan baris yang kolom pertamanya sama dengan &#8220;A&#8221; atau &#8220;C&#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;\">Sub<\/span> FilterMultipleCriteria()\n\n<span style=\"color: #0000ff;\">With<\/span> Range(\" <span style=\"color: #ff0000;\">A1:C11<\/span> \")\n    .AutoFilter Field:=1, Criteria1:=Array(\" <span style=\"color: #ff0000;\">A<\/span> \", \" <span style=\"color: #ff0000;\">C<\/span> \"), Operator:=xlFilterValues\n<span style=\"color: #0000ff;\">End With<\/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-37982 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mfil1.png\" alt=\"\" width=\"489\" height=\"391\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kumpulan data telah difilter untuk hanya menampilkan baris dengan kolom pertama sama dengan &#8220;A&#8221; atau &#8220;C&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kami hanya menyertakan dua kemungkinan nilai dalam fungsi <strong>Array()<\/strong> , namun jangan ragu untuk menyertakan sebanyak yang Anda inginkan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Gunakan filter otomatis dengan beberapa kriteria di beberapa kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin memfilter kumpulan data untuk hanya menampilkan baris dengan nilai kolom Tim sama dengan A <em>dan<\/em> nilai kolom Posisi sama dengan Penjaga.<\/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;\">Sub<\/span> FilterMultipleCriteria()\n\n<span style=\"color: #0000ff;\">With<\/span> Range(\" <span style=\"color: #ff0000;\">A1:C11<\/span> \")\n    .AutoFilter Field:=1, Criteria1:=\" <span style=\"color: #ff0000;\">A<\/span> \"\n    .AutoFilter Field:=2, Criteria1:=\" <span style=\"color: #ff0000;\">Guard<\/span> \"\n<span style=\"color: #0000ff;\">End With<\/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-37983 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mfil2.png\" alt=\"\" width=\"498\" height=\"380\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Saya perhatikan bahwa kumpulan data difilter untuk hanya menampilkan baris yang nilai di kolom Tim sama dengan A <em>dan<\/em> nilai di kolom Posisi sama dengan Penjaga.<\/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\/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 \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghapus-duplikat\/\" target=\"_blank\" rel=\"noopener\">VBA: cara menghapus nilai duplikat<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk menggunakan Filter Otomatis di VBA dengan beberapa kriteria: Metode 1: Gunakan Filter Otomatis dengan Banyak Kriteria dalam Satu Kolom Sub FilterMultipleCriteria() With Range(&#8221; A1:C11 &#8220;) .AutoFilter Field:=1, Criteria1:=Array(&#8221; A &#8220;, &#8221; C &#8220;), Operator:=xlFilterValues End With End Sub Makro khusus ini akan memfilter semua baris dalam rentang A1:C11 di [&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 autofilter dengan beberapa kriteria - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan AutoFilter dengan beberapa kriteria di VBA, dengan beberapa 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\/vba-autofilter-beberapa-kriteria\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menggunakan autofilter dengan beberapa kriteria - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan AutoFilter dengan beberapa kriteria di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T02:58:19+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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/\",\"name\":\"VBA: Cara menggunakan autofilter dengan beberapa kriteria - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T02:58:19+00:00\",\"dateModified\":\"2023-07-07T02:58:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan AutoFilter dengan beberapa kriteria di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menggunakan autofilter dengan banyak kriteria\"}]},{\"@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 autofilter dengan beberapa kriteria - Statorial","description":"Tutorial ini menjelaskan cara menggunakan AutoFilter dengan beberapa kriteria di VBA, dengan beberapa 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\/vba-autofilter-beberapa-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menggunakan autofilter dengan beberapa kriteria - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan AutoFilter dengan beberapa kriteria di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-07T02:58:19+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":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/","url":"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/","name":"VBA: Cara menggunakan autofilter dengan beberapa kriteria - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T02:58:19+00:00","dateModified":"2023-07-07T02:58:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan AutoFilter dengan beberapa kriteria di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-autofilter-beberapa-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menggunakan autofilter dengan banyak kriteria"}]},{"@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\/4862"}],"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=4862"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4862\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}