{"id":2700,"date":"2023-07-21T02:56:00","date_gmt":"2023-07-21T02:56:00","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/"},"modified":"2023-07-21T02:56:00","modified_gmt":"2023-07-21T02:56:00","slug":"filter-muka-excel-tidak-mengandung","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/","title":{"rendered":"Filter tingkat lanjut excel: cara menggunakan \u201ctidak berisi\u201d"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan sintaks berikut untuk memfilter baris yang tidak berisi teks tertentu dalam <strong>filter tingkat lanjut<\/strong> Excel :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>&lt;&gt;*sometext*\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam dua skenario berbeda:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Filter baris yang tidak berisi teks tertentu<\/span><\/li>\n<li> <span style=\"color: #000000;\">Filter baris yang tidak berisi teks di antara beberapa baris<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Filter baris yang tidak berisi teks tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan total penjualan produk tertentu di wilayah tertentu untuk sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23771 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremultiple1-1.jpg\" alt=\"\" width=\"479\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin memfilter baris yang wilayahnya tidak berisi &#8221; <strong>Timur<\/strong> &#8220;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat menentukan serangkaian kriteria:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23782 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pas1-1.jpg\" alt=\"\" width=\"541\" height=\"478\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita bisa klik pada tab <strong>Data<\/strong> , lalu klik tombol <strong>Advanced Filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23783 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pas2-1.jpg\" alt=\"\" width=\"679\" height=\"507\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita akan memilih <strong>A1:C17<\/strong> sebagai <strong>rentang daftar<\/strong> dan <strong>F1:F2<\/strong> sebagai <strong>rentang kriteria<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23784 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pas3.jpg\" alt=\"\" width=\"575\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita mengklik <strong>OK<\/strong> , kumpulan data akan difilter untuk hanya menampilkan baris yang wilayahnya tidak berisi &#8221; <strong>Timur<\/strong> &#8220;:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23785 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pas4.jpg\" alt=\"\" width=\"541\" height=\"443\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Filter baris yang<\/strong><\/span> <span style=\"color: #000000;\"><strong>tidak berisi teks di antara beberapa baris<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan total penjualan produk tertentu di wilayah tertentu untuk sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23771 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremultiple1-1.jpg\" alt=\"\" width=\"479\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin memfilter baris yang wilayahnya tidak berisi &#8221; <strong>Timur<\/strong> &#8221; atau &#8221; <strong>Barat<\/strong> &#8220;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat menentukan serangkaian kriteria:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23786 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pas5.jpg\" alt=\"\" width=\"550\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita bisa klik pada tab <strong>Data<\/strong> lalu klik tombol <strong>Advanced Filter<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita akan memilih <strong>A1:C17<\/strong> sebagai <strong>rentang daftar<\/strong> dan <strong>F1:G2<\/strong> sebagai <strong>rentang kriteria<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23787 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pas6.jpg\" alt=\"\" width=\"602\" height=\"461\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita klik <strong>OK<\/strong> , dataset akan difilter untuk hanya menampilkan baris yang wilayahnya tidak berisi &#8221; <strong>Timur<\/strong> &#8221; atau &#8221; <strong>Barat<\/strong> &#8220;:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23788 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pas7.jpg\" alt=\"\" width=\"551\" height=\"373\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/filter-excel-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter banyak kolom di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/baris-filter-jumlah-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan baris yang difilter di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris yang difilter di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan sintaks berikut untuk memfilter baris yang tidak berisi teks tertentu dalam filter tingkat lanjut Excel : &lt;&gt;*sometext* Contoh berikut menunjukkan cara menggunakan fungsi ini dalam dua skenario berbeda: Filter baris yang tidak berisi teks tertentu Filter baris yang tidak berisi teks di antara beberapa baris Contoh 1: Filter baris yang tidak berisi [&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>Filter Tingkat Lanjut Excel: Cara Menggunakan &quot;Tidak Berisi&quot; - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan &quot;tidak mengandung&quot; dalam filter lanjutan Excel, 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\/filter-muka-excel-tidak-mengandung\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Filter Tingkat Lanjut Excel: Cara Menggunakan &quot;Tidak Berisi&quot; - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan &quot;tidak mengandung&quot; dalam filter lanjutan Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T02:56:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremultiple1-1.jpg\" \/>\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-muka-excel-tidak-mengandung\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/\",\"name\":\"Filter Tingkat Lanjut Excel: Cara Menggunakan &quot;Tidak Berisi&quot; - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T02:56:00+00:00\",\"dateModified\":\"2023-07-21T02:56:00+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan &quot;tidak mengandung&quot; dalam filter lanjutan Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Filter tingkat lanjut excel: cara menggunakan \u201ctidak berisi\u201d\"}]},{\"@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":"Filter Tingkat Lanjut Excel: Cara Menggunakan &quot;Tidak Berisi&quot; - Statorial","description":"Tutorial ini menjelaskan cara menggunakan &quot;tidak mengandung&quot; dalam filter lanjutan Excel, 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\/filter-muka-excel-tidak-mengandung\/","og_locale":"id_ID","og_type":"article","og_title":"Filter Tingkat Lanjut Excel: Cara Menggunakan &quot;Tidak Berisi&quot; - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan &quot;tidak mengandung&quot; dalam filter lanjutan Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/","og_site_name":"Statorials","article_published_time":"2023-07-21T02:56:00+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremultiple1-1.jpg"}],"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-muka-excel-tidak-mengandung\/","url":"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/","name":"Filter Tingkat Lanjut Excel: Cara Menggunakan &quot;Tidak Berisi&quot; - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T02:56:00+00:00","dateModified":"2023-07-21T02:56:00+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan &quot;tidak mengandung&quot; dalam filter lanjutan Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Filter tingkat lanjut excel: cara menggunakan \u201ctidak berisi\u201d"}]},{"@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\/2700"}],"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=2700"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2700\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}