{"id":3707,"date":"2023-07-16T00:46:21","date_gmt":"2023-07-16T00:46:21","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/"},"modified":"2023-07-16T00:46:21","modified_gmt":"2023-07-16T00:46:21","slug":"google-sheet-memfilter-beberapa-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/","title":{"rendered":"Google spreadsheet: cara memfilter kolom berdasarkan beberapa nilai"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus dasar berikut untuk memfilter kolom berdasarkan beberapa nilai di Google Spreadsheet:<\/span><\/p>\n

 =<\/span> FILTER<\/span> (<\/span> A1:C11<\/span> ,<\/span> REGEXMATCH<\/span> (<\/span> A1:A11<\/span> ,<\/span> \" string1|string2|string3<\/span> \"<\/span> )<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus khusus ini akan memfilter baris dalam rentang A1:C11<\/strong> untuk hanya menampilkan baris yang nilai dalam rentang A1:A11<\/strong> sama dengan string1, string2, atau string3.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Filter kolom berdasarkan beberapa nilai di Google Spreadsheet<\/strong><\/span><\/h2>\n
 Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang katakanlah kita ingin memfilter kumpulan data agar hanya menampilkan baris yang kolom Timnya berisi Heat atau Celtics.<\/span><\/p>\n
 Untuk melakukannya, kita dapat menggunakan rumus berikut:<\/span><\/p>\n
 =<\/span> FILTER<\/span> (<\/span> A1:C11<\/span> ,<\/span> REGEXMATCH<\/span> (<\/span> A1:A11<\/span> ,<\/span> \u201c Heat|Celtics<\/span> \u201d<\/span> )<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Filter<\/p>\n
 Perhatikan bahwa kumpulan data yang difilter hanya berisi baris dengan tim yang sama dengan Heat atau Celtics.<\/span><\/p>\n
 Perhatikan juga bahwa Anda dapat memfilter baris yang nama timnya tidak sama dengan<\/strong> Heat atau Celtics dengan menggunakan fungsi NOT<\/strong> di luar fungsi REGEXMATCH<\/strong> sebagai berikut:<\/span><\/p>\n
 =<\/span> FILTER<\/span> (<\/span> A1:C11<\/span> ,<\/span> NOT( REGEXMATCH<\/span> (<\/span> A1:A11<\/span> ,<\/span> \u201c Heat|Celtics<\/span> \u201d<\/span> )<\/span> ))<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa kumpulan data yang difilter hanya berisi baris yang timnya tidak setara<\/strong> dengan Heat atau Celtics.<\/span><\/p>\n
 Sumber daya tambahan<\/span><\/strong><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Google Spreadsheet: Cara Memfilter Menggunakan Rumus Kustom<\/a>
 Google Spreadsheet: cara memfilter dari sheet lain<\/a>
 Google Spreadsheet: cara memfilter dengan berbagai kondisi<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus dasar berikut untuk memfilter kolom berdasarkan beberapa nilai di Google Spreadsheet: = FILTER ( A1:C11 , REGEXMATCH ( A1:A11 , ” string1|string2|string3 ” ) ) Rumus khusus ini akan memfilter baris dalam rentang A1:C11 untuk hanya menampilkan baris yang nilai dalam rentang A1:A11 sama dengan string1, string2, atau string3. Contoh berikut […]<\/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 memfilter kolom berdasarkan beberapa nilai \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter kolom berdasarkan beberapa nilai di Google Spreadsheet, 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-sheet-memfilter-beberapa-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara memfilter kolom berdasarkan beberapa nilai \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter kolom berdasarkan beberapa nilai di Google Spreadsheet, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T00:46:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremultiple1.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\/google-sheet-memfilter-beberapa-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/\",\"name\":\"Google Spreadsheet: Cara memfilter kolom berdasarkan beberapa nilai \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T00:46:21+00:00\",\"dateModified\":\"2023-07-16T00:46:21+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter kolom berdasarkan beberapa nilai di Google Spreadsheet, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara memfilter kolom berdasarkan beberapa nilai\"}]},{\"@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 memfilter kolom berdasarkan beberapa nilai \u2013 Statologi","description":"Tutorial ini menjelaskan cara memfilter kolom berdasarkan beberapa nilai di Google Spreadsheet, 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-sheet-memfilter-beberapa-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara memfilter kolom berdasarkan beberapa nilai \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara memfilter kolom berdasarkan beberapa nilai di Google Spreadsheet, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-16T00:46:21+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremultiple1.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\/google-sheet-memfilter-beberapa-nilai\/","url":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/","name":"Google Spreadsheet: Cara memfilter kolom berdasarkan beberapa nilai \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T00:46:21+00:00","dateModified":"2023-07-16T00:46:21+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter kolom berdasarkan beberapa nilai di Google Spreadsheet, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara memfilter kolom berdasarkan beberapa nilai"}]},{"@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\/3707"}],"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=3707"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3707\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}