{"id":3200,"date":"2023-07-18T17:32:45","date_gmt":"2023-07-18T17:32:45","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/"},"modified":"2023-07-18T17:32:45","modified_gmt":"2023-07-18T17:32:45","slug":"filter-excel-berisi-beberapa-kata","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/","title":{"rendered":"Excel: cara memfilter sel yang berisi banyak kata"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan sintaks berikut untuk memfilter sel di Excel yang berisi banyak kata:<\/span><\/p>\n

 =FILTER( A2:B8<\/span> ,ISNUMBER(SEARCH(\"word1\", A2:A8<\/span> ))*ISNUMBER(SEARCH(\"word2\", A2:A8<\/span> )))\n<\/strong><\/pre>\n
 Rumus ini akan mengembalikan baris dalam rentang A2:B8<\/strong> dengan sel dalam rentang A2:A8<\/strong> berisi “kata1” dan “kata2”.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: memfilter sel yang berisi banyak kata<\/strong><\/span><\/h3>\n
 Misalkan kita memiliki kumpulan data berikut di Excel yang berisi jabatan dan tahun pengalaman anggota staf tim olahraga:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa menggunakan rumus berikut untuk memfilter baris yang judulnya berisi kata “Asisten” dan “Pelatih” di sel yang sama:<\/span><\/p>\n
 =FILTER( A2:B8<\/span> ,ISNUMBER(SEARCH(\"Assistant\", A2:A8<\/span> ))*ISNUMBER(SEARCH(\"Coach\", A2:A8<\/span> )))<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Sel<\/p>\n
 Kita dapat melihat bahwa filter hanya mengembalikan tiga baris yang berisi kata “Asisten” dan “Pelatih” di sel yang sama.<\/span><\/p>\n
 Penting untuk dicatat bahwa kita juga dapat menggunakan substring saat memfilter.<\/span><\/p>\n
 Misalnya, kita bisa menggunakan rumus berikut untuk memfilter baris yang judulnya berisi kata “Bantuan” dan “Pelatih” di sel yang sama:<\/span><\/p>\n
 =FILTER( A2:B8<\/span> ,ISNUMBER(SEARCH(\"Assist\", A2:A8<\/span> ))*ISNUMBER(SEARCH(\"Coach\", A2:A8<\/span> )))<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat melihat bahwa tiga sel yang dikembalikan berisi substring \u201cAssist\u201d dan string lengkap \u201cCoach\u201d di sel yang sama.<\/span><\/p>\n
 Catatan<\/strong> : Dalam masing-masing contoh ini, kita telah memfilter sel yang berisi dua kata spesifik, namun dengan menggunakan beberapa tanda bintang ( *<\/strong> ), kita dapat memfilter sel yang berisi kata spesifik sebanyak yang kita inginkan.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Excel: cara menghapus baris dengan teks tertentu<\/a>
Excel: cara memeriksa apakah sel berisi sebagian teks<\/a>
 Excel: cara memeriksa apakah sel berisi teks daftar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan sintaks berikut untuk memfilter sel di Excel yang berisi banyak kata: =FILTER( A2:B8 ,ISNUMBER(SEARCH(“word1”, A2:A8 ))*ISNUMBER(SEARCH(“word2″, A2:A8 ))) Rumus ini akan mengembalikan baris dalam rentang A2:B8 dengan sel dalam rentang A2:A8 berisi “kata1” dan “kata2”. Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: memfilter sel yang berisi banyak kata Misalkan […]<\/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":"\nExcel: Cara memfilter sel yang berisi banyak kata - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter sel di Excel yang berisi banyak kata, beserta 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-excel-berisi-beberapa-kata\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara memfilter sel yang berisi banyak kata - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter sel di Excel yang berisi banyak kata, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T17:32:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremultipletext1.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-excel-berisi-beberapa-kata\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/\",\"name\":\"Excel: Cara memfilter sel yang berisi banyak kata - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T17:32:45+00:00\",\"dateModified\":\"2023-07-18T17:32:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter sel di Excel yang berisi banyak kata, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara memfilter sel yang berisi banyak kata\"}]},{\"@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":"Excel: Cara memfilter sel yang berisi banyak kata - Statorial","description":"Tutorial ini menjelaskan cara memfilter sel di Excel yang berisi banyak kata, beserta 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-excel-berisi-beberapa-kata\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara memfilter sel yang berisi banyak kata - Statorial","og_description":"Tutorial ini menjelaskan cara memfilter sel di Excel yang berisi banyak kata, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/","og_site_name":"Statorials","article_published_time":"2023-07-18T17:32:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremultipletext1.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-excel-berisi-beberapa-kata\/","url":"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/","name":"Excel: Cara memfilter sel yang berisi banyak kata - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T17:32:45+00:00","dateModified":"2023-07-18T17:32:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter sel di Excel yang berisi banyak kata, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara memfilter sel yang berisi banyak kata"}]},{"@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\/3200"}],"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=3200"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3200\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}