{"id":4093,"date":"2023-07-13T15:45:51","date_gmt":"2023-07-13T15:45:51","guid":{"rendered":"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/"},"modified":"2023-07-13T15:45:51","modified_gmt":"2023-07-13T15:45:51","slug":"google-meninggalkan-filter-wildcard","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/","title":{"rendered":"Google spreadsheet: cara menggunakan filter dengan wildcard"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut di Google Sheets untuk menggunakan wildcard dalam fungsi FILTER<\/strong> :<\/span><\/p>\n

 =FILTER( A2:C11<\/span> ,search(\" avs<\/span> \", A2:A11<\/span> ))\n<\/span><\/strong><\/pre>\n
 Rumus khusus ini akan memfilter sel dalam rentang A2:C11<\/strong> agar hanya berisi baris yang nilai dalam A2:A11<\/strong> berisi “avs” di suatu tempat di dalam sel.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Gunakan FILTER dengan Wildcard di Google Spreadsheet<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang berisi informasi tentang berbagai pemain bola basket:<\/span><\/p>\n
 Sekarang katakanlah kita ingin memfilter kumpulan data agar hanya berisi baris yang nilainya di kolom Tim<\/strong> berisi “avs” di suatu tempat di namanya.<\/span><\/p>\n
 Kita bisa mengetikkan rumus berikut di sel A13<\/strong> untuk menerapkan filter ini:<\/span><\/p>\n
 =FILTER( A2:C11<\/span> ,search(\" avs<\/span> \", A2:A11<\/span> ))<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Filter<\/p>\n
 Perhatikan bahwa satu-satunya baris yang ditampilkan dalam kumpulan data yang difilter berisi string “avs” di suatu tempat di nama tim.<\/span><\/p>\n
 Untuk mencari string yang berbeda, cukup ganti “avs” dengan string lain dalam rumus.<\/span><\/p>\n
 Misalnya, kita bisa menggunakan rumus berikut untuk memfilter baris yang nama timnya mengandung “ets” di suatu tempat di namanya:<\/span><\/p>\n
 =FILTER( A2:C11<\/span> ,search(\" ets<\/span> \", A2:A11<\/span> ))<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang satu-satunya baris yang ditampilkan dalam kumpulan data yang difilter berisi string “ets” di suatu tempat di nama tim.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara menggunakan wildcard dalam kueri Google Sheets<\/a>
 Cara menggunakan COUNTIF dengan wildcard di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus berikut di Google Sheets untuk menggunakan wildcard dalam fungsi FILTER : =FILTER( A2:C11 ,search(” avs “, A2:A11 )) Rumus khusus ini akan memfilter sel dalam rentang A2:C11 agar hanya berisi baris yang nilai dalam A2:A11 berisi “avs” di suatu tempat di dalam sel. Contoh berikut menunjukkan cara menggunakan rumus ini dalam […]<\/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":"\nGoogle Spreadsheet: Cara menggunakan FILTER dengan Wildcard - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi FILTER dengan wildcard di Google Sheets, 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\/google-meninggalkan-filter-wildcard\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara menggunakan FILTER dengan Wildcard - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi FILTER dengan wildcard di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T15:45:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauvage2-1.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\/google-meninggalkan-filter-wildcard\/\",\"url\":\"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/\",\"name\":\"Google Spreadsheet: Cara menggunakan FILTER dengan Wildcard - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T15:45:51+00:00\",\"dateModified\":\"2023-07-13T15:45:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi FILTER dengan wildcard di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara menggunakan filter dengan wildcard\"}]},{\"@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":"Google Spreadsheet: Cara menggunakan FILTER dengan Wildcard - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi FILTER dengan wildcard di Google Sheets, 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\/google-meninggalkan-filter-wildcard\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menggunakan FILTER dengan Wildcard - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi FILTER dengan wildcard di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/","og_site_name":"Statorials","article_published_time":"2023-07-13T15:45:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauvage2-1.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\/google-meninggalkan-filter-wildcard\/","url":"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/","name":"Google Spreadsheet: Cara menggunakan FILTER dengan Wildcard - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T15:45:51+00:00","dateModified":"2023-07-13T15:45:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi FILTER dengan wildcard di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-meninggalkan-filter-wildcard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara menggunakan filter dengan wildcard"}]},{"@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\/4093"}],"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=4093"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4093\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}