{"id":2655,"date":"2023-07-21T07:50:24","date_gmt":"2023-07-21T07:50:24","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/"},"modified":"2023-07-21T07:50:24","modified_gmt":"2023-07-21T07:50:24","slug":"google-sheet-memfilter-beberapa-kondisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/","title":{"rendered":"Google spreadsheet: cara memfilter dengan berbagai kondisi"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut di Google Spreadsheet untuk memfilter data dengan beberapa kondisi:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Filter baris yang memenuhi beberapa kondisi<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=FILTER( <span style=\"color: #ff6600;\">A1:C10<\/span> , <span style=\"color: #800080;\">A1:A10<\/span> =\" <span style=\"color: #008000;\">A<\/span> \", <span style=\"color: #008080;\">C1:C10<\/span> &lt; <span style=\"color: #3366ff;\">20<\/span> )<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Filter ini mengembalikan baris dalam rentang A1:C10 dengan nilai kolom A sama dengan &#8220;A&#8221; <strong>dan<\/strong> nilai kolom C kurang dari 20.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Filter baris yang memenuhi salah satu dari beberapa kondisi<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=FILTER( <span style=\"color: #ff6600;\">A1:C10<\/span> , ( <span style=\"color: #800080;\">A1:A10<\/span> =\" <span style=\"color: #000000;\"><span style=\"color: #008000;\">A<\/span><\/span> \")+( <span style=\"color: #008080;\">C1:C10<\/span> &lt; <span style=\"color: #3366ff;\">20<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Filter ini mengembalikan baris dalam rentang A1:C10 dengan nilai kolom A sama dengan &#8220;A&#8221; <b>atau<\/b> nilai kolom C kurang dari 20.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23398 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre1-1.jpg\" alt=\"\" width=\"569\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Filter baris yang memenuhi beberapa kondisi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk memfilter semua baris yang timnya sama dengan &#8220;A&#8221; <strong>dan<\/strong> poinnya kurang dari 20:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=FILTER( <span style=\"color: #ff6600;\">A1:C10<\/span> , <span style=\"color: #800080;\">A1:A10<\/span> =\" <span style=\"color: #008000;\">A<\/span> \", <span style=\"color: #008080;\">C1:C10<\/span> &lt; <span style=\"color: #3366ff;\">20<\/span> )<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23399 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre2-1.jpg\" alt=\"\" width=\"493\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Satu-satunya garis yang dikembalikan adalah garis yang timnya sama dengan &#8220;A&#8221; <strong>dan<\/strong> poinnya kurang dari 20.<\/span><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Filter baris yang memenuhi salah satu dari beberapa kondisi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk memfilter semua baris yang timnya sama dengan &#8220;A&#8221; <b>atau<\/b> poinnya kurang dari 20:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=FILTER( <span style=\"color: #ff6600;\">A1:C10<\/span> , ( <span style=\"color: #800080;\">A1:A10<\/span> =\" <span style=\"color: #000000;\"><span style=\"color: #008000;\">A<\/span><\/span> \")+( <span style=\"color: #008080;\">C1:C10<\/span> &lt; <span style=\"color: #3366ff;\">20<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23400 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre3-1.jpg\" alt=\"\" width=\"514\" height=\"517\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Satu-satunya garis yang dikembalikan adalah garis yang timnya sama dengan &#8220;A&#8221; <strong>atau<\/strong> poinnya kurang dari 20.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/filter-google-sheet-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara memfilter sel yang berisi teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sumif-lembar-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara menggunakan SUMIF dengan banyak kolom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-di-beberapa-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara menambahkan beberapa lembar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut di Google Spreadsheet untuk memfilter data dengan beberapa kondisi: Metode 1: Filter baris yang memenuhi beberapa kondisi =FILTER( A1:C10 , A1:A10 =&#8221; A &#8220;, C1:C10 &lt; 20 ) Filter ini mengembalikan baris dalam rentang A1:C10 dengan nilai kolom A sama dengan &#8220;A&#8221; dan nilai kolom C kurang dari 20. Metode [&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>Google Spreadsheet: Cara memfilter dengan berbagai kondisi - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter data menggunakan beberapa kondisi di Google Spreadsheet, dengan beberapa 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-kondisi\/\" \/>\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 dengan berbagai kondisi - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter data menggunakan beberapa kondisi di Google Spreadsheet, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T07:50:24+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\/google-sheet-memfilter-beberapa-kondisi\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/\",\"name\":\"Google Spreadsheet: Cara memfilter dengan berbagai kondisi - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T07:50:24+00:00\",\"dateModified\":\"2023-07-21T07:50:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter data menggunakan beberapa kondisi di Google Spreadsheet, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara memfilter dengan berbagai kondisi\"}]},{\"@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 dengan berbagai kondisi - Statorial","description":"Tutorial ini menjelaskan cara memfilter data menggunakan beberapa kondisi di Google Spreadsheet, dengan beberapa 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-kondisi\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara memfilter dengan berbagai kondisi - Statorial","og_description":"Tutorial ini menjelaskan cara memfilter data menggunakan beberapa kondisi di Google Spreadsheet, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/","og_site_name":"Statorials","article_published_time":"2023-07-21T07:50:24+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\/google-sheet-memfilter-beberapa-kondisi\/","url":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/","name":"Google Spreadsheet: Cara memfilter dengan berbagai kondisi - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T07:50:24+00:00","dateModified":"2023-07-21T07:50:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter data menggunakan beberapa kondisi di Google Spreadsheet, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kondisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara memfilter dengan berbagai kondisi"}]},{"@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\/2655"}],"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=2655"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2655\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}