{"id":3730,"date":"2023-07-15T21:29:47","date_gmt":"2023-07-15T21:29:47","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/"},"modified":"2023-07-15T21:29:47","modified_gmt":"2023-07-15T21:29:47","slug":"filter-google-sheet-berdasarkan-daftar-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/","title":{"rendered":"Cara memfilter berdasarkan daftar nilai di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk memfilter kumpulan data berdasarkan daftar nilai di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">FILTER<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2:C11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">COUNTIF<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #800080;\">E2:E5<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #008080;\">A2:A11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini memfilter sel dalam rentang <strong>A2:C11<\/strong> untuk hanya mengembalikan baris yang sel dalam rentang <strong>A2:A11<\/strong> berisi nilai dari daftar nilai dalam rentang <strong>E2:E5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan dataset berikut ke Google Sheets yang berisi informasi berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30399 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/liste1.jpg\" alt=\"\" width=\"600\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Langkah 2: Tentukan daftar nilai<\/span><\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari kita tentukan daftar nilai tim yang ingin kita filter:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30400 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/liste2.jpg\" alt=\"\" width=\"637\" height=\"467\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Filter berdasarkan daftar nilai<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketikkan rumus berikut ke dalam sel <strong>A14<\/strong> untuk memfilter kumpulan data berdasarkan daftar tim yang kita tentukan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">FILTER<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2:C11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">COUNTIF<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #800080;\">E2:E5<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #008080;\">A2:A11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/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=\"aligncenter wp-image-30402\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/liste3-1.jpg\" alt=\"Filter Google Spreadsheet berdasarkan daftar nilai\" width=\"624\" height=\"534\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kumpulan data yang difilter hanya berisi baris-baris yang nama tim dari kumpulan data asli dalam rentang <strong>A2:C11<\/strong> ditemukan dalam daftar nama dalam rentang <strong>E2:E5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Fungsi <strong>FILTER<\/strong> tidak peka huruf besar-kecil. Artinya jika Anda mengetik &#8220;nets&#8221; dan bukan &#8220;Nets&#8221;, fungsi tersebut akan selalu mengembalikan baris dengan &#8220;Nets&#8221; di kolom Tim.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\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 dapat menggunakan sintaks berikut untuk memfilter kumpulan data berdasarkan daftar nilai di Google Spreadsheet: = FILTER ( A2:C11 , COUNTIF ( E2:E5 , A2:A11 ) ) Rumus khusus ini memfilter sel dalam rentang A2:C11 untuk hanya mengembalikan baris yang sel dalam rentang A2:A11 berisi nilai dari daftar nilai dalam rentang E2:E5 . Contoh langkah [&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 berdasarkan daftar nilai di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter kumpulan data berdasarkan daftar 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\/filter-google-sheet-berdasarkan-daftar-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara memfilter berdasarkan daftar nilai di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter kumpulan data berdasarkan daftar nilai di Google Spreadsheet, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T21:29:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/liste1.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-berdasarkan-daftar-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/\",\"name\":\"Cara memfilter berdasarkan daftar nilai di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T21:29:47+00:00\",\"dateModified\":\"2023-07-15T21:29:47+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter kumpulan data berdasarkan daftar nilai di Google Spreadsheet, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memfilter berdasarkan daftar nilai di google spreadsheet\"}]},{\"@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 berdasarkan daftar nilai di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara memfilter kumpulan data berdasarkan daftar 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\/filter-google-sheet-berdasarkan-daftar-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Cara memfilter berdasarkan daftar nilai di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara memfilter kumpulan data berdasarkan daftar nilai di Google Spreadsheet, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-15T21:29:47+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/liste1.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-berdasarkan-daftar-nilai\/","url":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/","name":"Cara memfilter berdasarkan daftar nilai di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T21:29:47+00:00","dateModified":"2023-07-15T21:29:47+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter kumpulan data berdasarkan daftar nilai di Google Spreadsheet, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memfilter berdasarkan daftar nilai di google spreadsheet"}]},{"@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\/3730"}],"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=3730"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3730\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3730"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3730"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}