{"id":2344,"date":"2023-07-22T16:46:55","date_gmt":"2023-07-22T16:46:55","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/"},"modified":"2023-07-22T16:46:55","modified_gmt":"2023-07-22T16:46:55","slug":"google-sheet-memfilter-beberapa-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/","title":{"rendered":"Cara memfilter banyak kolom di google spreadsheet (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara memfilter beberapa kolom di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan data berikut yang menunjukkan total penjualan produk tertentu di wilayah tertentu untuk suatu perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21247 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot11.png\" alt=\"\" width=\"539\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Terapkan filter ke beberapa kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin memfilter baris dengan wilayah &#8220;Timur&#8221; atau produknya &#8220;A&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, klik pada sel <strong>A1<\/strong> lalu klik pada tab <strong>Data<\/strong> lalu klik <strong>Buat filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21260 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre1.png\" alt=\"\" width=\"539\" height=\"484\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik ikon Filter di samping Wilayah, lalu klik <strong>Filter berdasarkan Kondisi<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di menu tarik-turun, klik <strong>Tidak Ada<\/strong> , lalu gulir ke <strong>Rumus Khusus<\/strong> dan masukkan rumus berikut:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #000000;\">=OR(A:A=\"East\", B:B=\"A\")<\/span>\n<\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21261 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre2.png\" alt=\"\" width=\"447\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , data akan difilter untuk hanya menampilkan baris dengan wilayah Timur atau produk A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21262 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre3.png\" alt=\"\" width=\"509\" height=\"349\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin menerapkan filter dengan Wilayah adalah Timur <em>dan<\/em> Produk adalah A, Anda dapat menggunakan rumus berikut:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #000000;\">=AND(A:A=\"East\", B:B=\"A\")<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21263 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre4.png\" alt=\"\" width=\"448\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , data akan difilter untuk hanya menampilkan baris dengan wilayah Timur <em>dan<\/em> produk A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21264 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre5.png\" alt=\"\" width=\"471\" height=\"359\" srcset=\"\" sizes=\"\"><\/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-sumif-lembar-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan SUMIF dengan banyak kolom di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-di-beberapa-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan beberapa lembar di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh langkah demi langkah berikut menunjukkan cara memfilter beberapa kolom di Google Spreadsheet. Langkah 1: Masukkan datanya Pertama, masukkan data berikut yang menunjukkan total penjualan produk tertentu di wilayah tertentu untuk suatu perusahaan: Langkah 2: Terapkan filter ke beberapa kolom Sekarang katakanlah kita ingin memfilter baris dengan wilayah &#8220;Timur&#8221; atau produknya &#8220;A&#8221;. Untuk melakukan ini, [&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>Cara Memfilter Banyak Kolom di Google Sheets (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter beberapa kolom di Google Sheets, 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-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Memfilter Banyak Kolom di Google Sheets (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter beberapa kolom di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T16:46:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot11.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-sheet-memfilter-beberapa-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/\",\"name\":\"Cara Memfilter Banyak Kolom di Google Sheets (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T16:46:55+00:00\",\"dateModified\":\"2023-07-22T16:46:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter beberapa kolom di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memfilter banyak kolom di google spreadsheet (dengan contoh)\"}]},{\"@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":"Cara Memfilter Banyak Kolom di Google Sheets (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara memfilter beberapa kolom di Google Sheets, 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-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Memfilter Banyak Kolom di Google Sheets (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara memfilter beberapa kolom di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-22T16:46:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot11.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-sheet-memfilter-beberapa-kolom\/","url":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/","name":"Cara Memfilter Banyak Kolom di Google Sheets (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T16:46:55+00:00","dateModified":"2023-07-22T16:46:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter beberapa kolom di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memfilter banyak kolom di google spreadsheet (dengan contoh)"}]},{"@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\/2344"}],"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=2344"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2344\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}