{"id":2701,"date":"2023-07-21T02:54:19","date_gmt":"2023-07-21T02:54:19","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/"},"modified":"2023-07-21T02:54:19","modified_gmt":"2023-07-21T02:54:19","slug":"filter-muka-excel-berisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/","title":{"rendered":"Filter lanjutan excel: cara menggunakan &quot;berisi&quot;"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan sintaks berikut untuk memfilter baris yang berisi teks tertentu dalam <strong>filter lanjutan<\/strong> Excel :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>*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 berisi teks tertentu<\/span><\/li>\n<li> <span style=\"color: #000000;\">Filter baris yang berisi salah satu dari beberapa teks<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Filter baris yang 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 mengandung &#8221; <strong>st<\/strong> &#8221; pada namanya.<\/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-23793 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/contienttext1.jpg\" alt=\"\" width=\"531\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita dapat mengklik tab <strong>Data<\/strong> , lalu klik tombol <strong>Filter lanjutan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23794 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/contienttext2.jpg\" alt=\"\" width=\"647\" height=\"543\" 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-23795 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/contienttext3.jpg\" alt=\"\" width=\"594\" height=\"520\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita klik <strong>OK<\/strong> , dataset akan difilter untuk hanya menampilkan baris yang wilayahnya berisi teks &#8221; <strong>st<\/strong> &#8220;:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23796 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/contienttext4.jpg\" alt=\"\" width=\"565\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Filter baris<\/strong><\/span> <span style=\"color: #000000;\"><strong>yang berisi salah satu dari beberapa teks<\/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 berisi &#8221; <strong>st<\/strong> &#8221; atau &#8221; <strong>Nor<\/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-23798 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/contienttext5-1.jpg\" alt=\"\" width=\"559\" height=\"411\" 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;\">Kami akan memilih <strong>A1:C17<\/strong> sebagai <strong>rentang daftar<\/strong> dan <strong>F1:G3<\/strong> sebagai <strong>rentang kriteria<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23799 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/contienttext6.jpg\" alt=\"\" width=\"581\" height=\"456\" 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 berisi &#8221; <strong>st<\/strong> &#8221; atau &#8221; <strong>Nor<\/strong> &#8220;:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23800 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/contienttext7.jpg\" alt=\"\" width=\"564\" height=\"376\" 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 berisi teks tertentu dalam filter lanjutan Excel : *sometext* Contoh berikut menunjukkan cara menggunakan fungsi ini dalam dua skenario berbeda: Filter baris yang berisi teks tertentu Filter baris yang berisi salah satu dari beberapa teks Contoh 1: Filter baris yang berisi teks tertentu Misalkan kita memiliki [&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 lanjutan Excel: Cara menggunakan &quot;Berisi&quot; - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berisi&quot; dalam filter lanjutan Excel, beserta contohnya.\" \/>\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-berisi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Filter lanjutan Excel: Cara menggunakan &quot;Berisi&quot; - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berisi&quot; dalam filter lanjutan Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T02:54:19+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-berisi\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/\",\"name\":\"Filter lanjutan Excel: Cara menggunakan &quot;Berisi&quot; - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T02:54:19+00:00\",\"dateModified\":\"2023-07-21T02:54:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berisi&quot; dalam filter lanjutan Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Filter lanjutan excel: cara menggunakan &quot;berisi&quot;\"}]},{\"@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 lanjutan Excel: Cara menggunakan &quot;Berisi&quot; - Statologi","description":"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berisi&quot; dalam filter lanjutan Excel, beserta contohnya.","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-berisi\/","og_locale":"id_ID","og_type":"article","og_title":"Filter lanjutan Excel: Cara menggunakan &quot;Berisi&quot; - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berisi&quot; dalam filter lanjutan Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/","og_site_name":"Statorials","article_published_time":"2023-07-21T02:54:19+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-berisi\/","url":"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/","name":"Filter lanjutan Excel: Cara menggunakan &quot;Berisi&quot; - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T02:54:19+00:00","dateModified":"2023-07-21T02:54:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berisi&quot; dalam filter lanjutan Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Filter lanjutan excel: cara menggunakan &quot;berisi&quot;"}]},{"@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\/2701"}],"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=2701"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2701\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}