{"id":4196,"date":"2023-07-12T22:43:34","date_gmt":"2023-07-12T22:43:34","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/"},"modified":"2023-07-12T22:43:34","modified_gmt":"2023-07-12T22:43:34","slug":"filter-google-sheet-atau","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/","title":{"rendered":"Google sheets: cara menggunakan fungsi filter dengan or"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut di Google Sheets untuk menggunakan fungsi FILTER<\/strong> dengan logika OR<\/strong> :<\/span><\/p>\n

 =FILTER( A1:C10<\/span> , ( A1:A10<\/span> =\" A<\/span><\/span> \")+( C1:C10<\/span> < 20<\/span> ))<\/strong><\/pre>\n
 Filter ini mengembalikan baris dalam rentang A1:C10 dengan nilai kolom A sama dengan “A” atau<\/b> nilai kolom C kurang dari 20.<\/span><\/p>\n
 Catatan<\/strong> : Tanda plus ( +<\/strong> ) digunakan sebagai operator OR di Google Sheets.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara menggunakan fungsi filter OR di Google Sheets<\/strong><\/h2>\n
 Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat menggunakan rumus berikut untuk memfilter semua baris yang timnya sama dengan “A” atau<\/b> poinnya kurang dari 20:<\/span><\/p>\n
 =FILTER( A1:C10<\/span> , ( A1:A10<\/span> =\" A<\/span><\/span> \")+( C1:C10<\/span> < 20<\/span> ))<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Fungsi<\/p>\n
 Satu-satunya garis yang dikembalikan adalah garis yang timnya sama dengan “A” atau<\/strong> poinnya kurang dari 20.<\/span><\/p>\n
 Kita juga dapat menggunakan lebih banyak tanda tambah ( +<\/strong> ) pada fungsi FILTER<\/strong> untuk menerapkan lebih banyak operator OR<\/strong> .<\/span><\/p>\n
 Misalnya, kita dapat menggunakan sintaks berikut untuk memfilter garis di mana tim adalah “A” atau<\/b> posisinya adalah “Penjaga” atau<\/strong> poin lebih besar dari 15:<\/span><\/p>\n
 =FILTER( A1:C10<\/span> , ( A1:A10<\/span> =\" A<\/span><\/span> \")+ ( B1:B10<\/span> =\" Guard<\/span> \")+<\/span> ( C1:C10<\/span> > 15<\/span> ))<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Fungsi FILTER<\/strong> ini mengembalikan baris dari kumpulan data asli jika salah satu dari tiga kondisi terpenuhi.<\/span><\/p>\n
 Sumber daya tambahan<\/span><\/strong><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
Google Sheets: cara memfilter sel yang berisi teks<\/a>
 Google Sheets: Cara menggunakan SUMIF dengan banyak kolom<\/a>
 Google Spreadsheet: cara menambahkan beberapa lembar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut di Google Sheets untuk menggunakan fungsi FILTER dengan logika OR : =FILTER( A1:C10 , ( A1:A10 =” A “)+( C1:C10 < 20 )) Filter ini mengembalikan baris dalam rentang A1:C10 dengan nilai kolom A sama dengan “A” atau nilai kolom C kurang dari 20. Catatan : Tanda plus ( […]<\/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 Sheets: Cara menggunakan fungsi FILTER dengan OR - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi FILTER di Google Sheets dengan logika OR, 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-google-sheet-atau\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets: Cara menggunakan fungsi FILTER dengan OR - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi FILTER di Google Sheets dengan logika OR, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T22:43:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre1-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-google-sheet-atau\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/\",\"name\":\"Google Sheets: Cara menggunakan fungsi FILTER dengan OR - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T22:43:34+00:00\",\"dateModified\":\"2023-07-12T22:43:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi FILTER di Google Sheets dengan logika OR, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara menggunakan fungsi filter dengan or\"}]},{\"@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 Sheets: Cara menggunakan fungsi FILTER dengan OR - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi FILTER di Google Sheets dengan logika OR, 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-google-sheet-atau\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets: Cara menggunakan fungsi FILTER dengan OR - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi FILTER di Google Sheets dengan logika OR, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/","og_site_name":"Statorials","article_published_time":"2023-07-12T22:43:34+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre1-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-google-sheet-atau\/","url":"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/","name":"Google Sheets: Cara menggunakan fungsi FILTER dengan OR - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T22:43:34+00:00","dateModified":"2023-07-12T22:43:34+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi FILTER di Google Sheets dengan logika OR, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-google-sheet-atau\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-google-sheet-atau\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara menggunakan fungsi filter dengan or"}]},{"@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\/4196"}],"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=4196"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4196\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}