{"id":2727,"date":"2023-07-20T23:59:43","date_gmt":"2023-07-20T23:59:43","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/"},"modified":"2023-07-20T23:59:43","modified_gmt":"2023-07-20T23:59:43","slug":"filter-lembar-google-dari-lembar-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/","title":{"rendered":"Google spreadsheet: cara memfilter dari sheet lain"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk memfilter data dari sheet lain di Google Spreadsheet:<\/span><\/p>\n

 =<\/span> FILTER<\/span> (<\/span> All_Teams!A2:C11<\/span> ,<\/span> All_Teams!B2:B11<\/span> =<\/span> \" Western<\/span> \"<\/span> )<\/span>\n<\/strong><\/pre>\n
 Fungsi khusus ini akan mengembalikan semua baris dalam rentang A2:C11<\/strong> pada lembar berjudul All_Teams<\/strong> dengan nilai dalam rentang B2:B11<\/strong> sama dengan “Barat”.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Memfilter dari sheet lain di Google Spreadsheet<\/strong><\/span><\/h3>\n
 Katakanlah kita memiliki sheet berikut bernama All_Teams<\/b> di Google Sheets yang berisi data berbagai tim bola basket:<\/span><\/p>\n
 \"\"<\/span><\/p>\n
 Sekarang katakanlah kita ingin berpindah ke sheet bernama Spesifik_Teams<\/b> dan hanya menampilkan All_Teams<\/strong> yang merupakan bagian dari Wilayah Barat.<\/span><\/p>\n
 Kita dapat menggunakan sintaks berikut untuk melakukan ini:<\/span><\/p>\n
 =<\/span> FILTER<\/span> (<\/span> All_Teams!A2:C11<\/span> ,<\/span> All_Teams!B2:B11<\/span> =<\/span> \" Western<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n
 Berikut cara menggunakan rumus ini dalam praktiknya:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa fungsi FILTER<\/strong> ini mengembalikan semua baris di lembar All_Teams<\/strong> dengan kolom konferensi sama dengan “Barat”.<\/span><\/span><\/p>\n
 Potensi Kesalahan #1: Ukuran Rentang Tidak Kompatibel<\/span><\/strong><\/span><\/h3>\n
 Saat menggunakan fungsi FILTER<\/strong> , Anda mungkin menerima kesalahan jika menggunakan dua rentang yang ukurannya tidak sama.<\/span><\/p>\n
 Misalnya, kita menggunakan fungsi FILTER berikut:<\/span><\/p>\n
 =<\/span> FILTER<\/span> (<\/span> All_Teams!A1:C11<\/span> ,<\/span> All_Teams!B2:B11<\/span> =<\/span> \" Western<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n
 Baris pertama A1:C11<\/strong> tidak berisi jumlah baris yang sama dengan baris kedua B2:B11<\/strong> , jadi kita akan menerima kesalahan:<\/span> <\/p>\n
\"\"<\/p>\n
 Untuk memperbaiki kesalahan ini, cukup pastikan kedua rentang berisi jumlah baris yang sama.<\/span><\/p>\n
 Potensi Kesalahan #2: Menggunakan Kutipan Tunggal<\/strong><\/span><\/h3>\n
 Saat menggunakan fungsi FILTER<\/strong> , Anda mungkin menerima kesalahan jika menggunakan tanda kutip tunggal, bukan tanda kutip ganda.<\/span><\/p>\n
 Misalnya, kita menggunakan fungsi FILTER berikut:<\/span><\/p>\n
 =<\/span> FILTER<\/span> (<\/span> All_Teams!A1:C11<\/span> ,<\/span> All_Teams!B2:B11<\/span> = '<\/span> Western<\/span> '<\/span> )<\/span><\/strong><\/pre>\n
 Karena kami menempatkan kata Western<\/em> dalam tanda kutip tunggal, bukan tanda kutip ganda, kami menerima kesalahan:<\/span> <\/p>\n
\"\"<\/p>\n
 Untuk memperbaiki kesalahan ini, cukup gunakan tanda kutip ganda.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi FILTER<\/strong> di sini<\/a> .<\/span><\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Google Spreadsheet: cara memfilter dengan berbagai kondisi<\/a>
 Google Spreadsheet: cara memfilter berdasarkan rentang tanggal<\/a>
Google Sheets: cara memfilter sel yang berisi teks<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk memfilter data dari sheet lain di Google Spreadsheet: = FILTER ( All_Teams!A2:C11 , All_Teams!B2:B11 = ” Western ” ) Fungsi khusus ini akan mengembalikan semua baris dalam rentang A2:C11 pada lembar berjudul All_Teams dengan nilai dalam rentang B2:B11 sama dengan “Barat”. Contoh berikut menunjukkan cara menggunakan sintaksis ini […]<\/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 Spreadsheet: Cara memfilter dari sheet lain - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter data dari sheet lain di Google Sheets, 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-lembar-google-dari-lembar-lain\/\" \/>\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 dari sheet lain - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter data dari sheet lain di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T23:59:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtrerunautre1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/\",\"name\":\"Google Spreadsheet: Cara memfilter dari sheet lain - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T23:59:43+00:00\",\"dateModified\":\"2023-07-20T23:59:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter data dari sheet lain di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara memfilter dari sheet lain\"}]},{\"@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 dari sheet lain - Statorial","description":"Tutorial ini menjelaskan cara memfilter data dari sheet lain di Google Sheets, 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-lembar-google-dari-lembar-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara memfilter dari sheet lain - Statorial","og_description":"Tutorial ini menjelaskan cara memfilter data dari sheet lain di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-20T23:59:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtrerunautre1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/","url":"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/","name":"Google Spreadsheet: Cara memfilter dari sheet lain - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T23:59:43+00:00","dateModified":"2023-07-20T23:59:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter data dari sheet lain di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara memfilter dari sheet lain"}]},{"@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\/2727"}],"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=2727"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2727\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2727"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2727"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}