{"id":3168,"date":"2023-07-18T21:22:45","date_gmt":"2023-07-18T21:22:45","guid":{"rendered":"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/"},"modified":"2023-07-18T21:22:45","modified_gmt":"2023-07-18T21:22:45","slug":"rumus-khusus-filter-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/","title":{"rendered":"Google spreadsheet: cara memfilter menggunakan rumus khusus"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda sering kali ingin memfilter data menggunakan rumus khusus di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan fitur <strong>Filter berdasarkan Kondisi<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Cara memfilter menggunakan rumus khusus di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26905 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/personnalise1-1.jpg\" alt=\"\" width=\"477\" height=\"459\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin memfilter baris yang kolom Pemainnya memiliki nama &#8220;Baik&#8221; atau &#8220;Luar Biasa&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat menyorot rentang sel <strong>A1:B12<\/strong> , lalu klik tab <strong>Data<\/strong> di sepanjang pita atas, lalu klik <strong>Buat Filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26906 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/personnalise2-1.jpg\" alt=\"\" width=\"617\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikutnya, klik ikon filter di sebelah <strong>Pembaca<\/strong> , lalu klik <strong>Filter berdasarkan Kondisi<\/strong> , lalu gulir ke bawah daftar dan klik <strong>Rumus khusus adalah<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26907\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/personnalise3.jpg\" alt=\"Filter Google Spreadsheet menggunakan rumus khusus\" width=\"392\" height=\"590\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ketik rumus berikut di kotak Rumus khusus:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=OR(REGEXMATCH( <span style=\"color: #ff6600;\">A:A<\/span> ,\" <span style=\"color: #008000;\">Good<\/span> \"),REGEXMATCH( <span style=\"color: #ff6600;\">A:A<\/span> ,\" <span style=\"color: #008000;\">Great<\/span> \"))\n<\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26908 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/personnalise4.jpg\" alt=\"\" width=\"443\" height=\"656\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , data akan secara otomatis difilter untuk menampilkan hanya baris yang kolom Pemainnya memiliki nama &#8220;Baik&#8221; atau &#8220;Luar Biasa&#8221;:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26909 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/personnalise5.jpg\" alt=\"\" width=\"465\" height=\"383\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini hanyalah contoh penggunaan rumus khusus untuk memfilter baris di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ada banyak sekali rumus yang bisa Anda masukkan ke dalam kotak rumus khusus bergantung pada cara Anda ingin memfilter kumpulan data Anda sendiri.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/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\/google-sheet-menjumlahkan-baris-yang-difilter\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan baris yang difilter di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter beberapa kolom di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sumif-lembar-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan SUMIF dengan banyak kolom di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda sering kali ingin memfilter data menggunakan rumus khusus di Google Spreadsheet. Untungnya, hal ini mudah dilakukan menggunakan fitur Filter berdasarkan Kondisi . Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Cara memfilter menggunakan rumus khusus di Google Spreadsheet Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket: [&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 Menggunakan Rumus Khusus - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter data menggunakan rumus khusus di Google Spreadsheet, 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\/rumus-khusus-filter-google-sheet\/\" \/>\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 Menggunakan Rumus Khusus - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter data menggunakan rumus khusus di Google Spreadsheet, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T21:22:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/personnalise1-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\/rumus-khusus-filter-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/\",\"name\":\"Google Spreadsheet: Cara Memfilter Menggunakan Rumus Khusus - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T21:22:45+00:00\",\"dateModified\":\"2023-07-18T21:22:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter data menggunakan rumus khusus di Google Spreadsheet, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara memfilter menggunakan rumus khusus\"}]},{\"@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 Menggunakan Rumus Khusus - Statologi","description":"Tutorial ini menjelaskan cara memfilter data menggunakan rumus khusus di Google Spreadsheet, 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\/rumus-khusus-filter-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara Memfilter Menggunakan Rumus Khusus - Statologi","og_description":"Tutorial ini menjelaskan cara memfilter data menggunakan rumus khusus di Google Spreadsheet, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-18T21:22:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/personnalise1-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\/rumus-khusus-filter-google-sheet\/","url":"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/","name":"Google Spreadsheet: Cara Memfilter Menggunakan Rumus Khusus - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T21:22:45+00:00","dateModified":"2023-07-18T21:22:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter data menggunakan rumus khusus di Google Spreadsheet, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rumus-khusus-filter-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara memfilter menggunakan rumus khusus"}]},{"@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\/3168"}],"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=3168"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3168\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}