{"id":4091,"date":"2023-07-13T16:03:15","date_gmt":"2023-07-13T16:03:15","guid":{"rendered":"https:\/\/statorials.org\/id\/rentang-impor-filter-google-sheet\/"},"modified":"2023-07-13T16:03:15","modified_gmt":"2023-07-13T16:03:15","slug":"rentang-impor-filter-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rentang-impor-filter-google-sheet\/","title":{"rendered":"Google spreadsheet: cara memfilter data importrange"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan fungsi IMPORTRANGE<\/strong> di Google Spreadsheet untuk mengimpor data dari spreadsheet lain.<\/span><\/p>\n

Untuk menerapkan filter ke fungsi IMPORTRANGE<\/strong> , Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n

 =FILTER(IMPORTRANGE(\" URL<\/span> \", \" sheet1!A1:C12<\/span> \"),\n        INDEX(IMPORTRANGE(\" URL<\/span> \", \" sheet1!A1:C12<\/span> \"), 0<\/span> , 2<\/span> )=\" Spurs<\/span> \")<\/strong><\/pre>\n
 Contoh khusus ini akan mengimpor sel dalam rentang A1:C12<\/strong> pada lembar yang disebut Lembar 1<\/strong> dari buku kerja dan memfilter rentang tersebut untuk memperlihatkan hanya baris yang nilai di kolom 2<\/strong> sama dengan “Spurs”.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara memfilter data IMPORTRANGE<\/strong><\/span><\/h2>\n
 Katakanlah kita ingin mengimpor data dari Google Spreadsheet dengan sheet bernama stats<\/strong> yang terletak di URL berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Mari kita asumsikan juga bahwa kita hanya ingin mengimpor baris yang nilainya di kolom kedua (kolom “Tim”) memiliki nilai “Spurs”.<\/span><\/p>\n
 Kita dapat mengetikkan rumus berikut ke dalam sel A1<\/strong> pada spreadsheet kita saat ini untuk mengimpor data khusus ini:<\/span><\/p>\n
 =FILTER(IMPORTRANGE(\" 1AdlE9V0aYMdrCmAGtvGXIEfo3szQ1tWRJ2HhJkUhg_4<\/span> \", \" stats!A1:C12<\/span> \"),\n        INDEX(IMPORTRANGE(\" 1AdlE9V0aYMdrCmAGtvGXIEfo3szQ1tWRJ2HhJkUhg_4<\/span> \", \" stats!A1:C12<\/span> \"), 0<\/span> , 2<\/span> )=\" Spurs<\/span> \")<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya:<\/span> <\/p>\n
\"Google<\/p>\n
 Perhatikan bahwa hanya baris dengan nilai di kolom Tim sama dengan \u201cSpurs\u201d yang diimpor.<\/span><\/p>\n
 Untuk memfilter baris yang kolom Timnya sama dengan nama berbeda, cukup ganti “Spurs” dengan nama tim lain di rumus.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Google Spreadsheet: Gunakan IMPORTRANGE dengan beberapa lembar<\/a>
 Google Sheets: Cara menggunakan IMPORTRANGE dengan ketentuan
 Google Sheets: Cara menggunakan VLOOKUP dari buku kerja lain<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan fungsi IMPORTRANGE di Google Spreadsheet untuk mengimpor data dari spreadsheet lain. Untuk menerapkan filter ke fungsi IMPORTRANGE , Anda dapat menggunakan sintaks berikut: =FILTER(IMPORTRANGE(” URL “, ” sheet1!A1:C12 “), INDEX(IMPORTRANGE(” URL “, ” sheet1!A1:C12 “), 0 , 2 )=” Spurs “) Contoh khusus ini akan mengimpor sel dalam rentang A1:C12 pada lembar […]<\/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 Data PENTING - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter data IMPORTRANGE 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\/rentang-impor-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 Data PENTING - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter data IMPORTRANGE di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rentang-impor-filter-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T16:03:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/q3.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\/rentang-impor-filter-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/rentang-impor-filter-google-sheet\/\",\"name\":\"Google Spreadsheet: Cara Memfilter Data PENTING - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T16:03:15+00:00\",\"dateModified\":\"2023-07-13T16:03:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter data IMPORTRANGE di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rentang-impor-filter-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rentang-impor-filter-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rentang-impor-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 data importrange\"}]},{\"@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 Data PENTING - Statorial","description":"Tutorial ini menjelaskan cara memfilter data IMPORTRANGE 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\/rentang-impor-filter-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara Memfilter Data PENTING - Statorial","og_description":"Tutorial ini menjelaskan cara memfilter data IMPORTRANGE di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/rentang-impor-filter-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-13T16:03:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/q3.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\/rentang-impor-filter-google-sheet\/","url":"https:\/\/statorials.org\/id\/rentang-impor-filter-google-sheet\/","name":"Google Spreadsheet: Cara Memfilter Data PENTING - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T16:03:15+00:00","dateModified":"2023-07-13T16:03:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter data IMPORTRANGE di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rentang-impor-filter-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rentang-impor-filter-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rentang-impor-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 data importrange"}]},{"@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\/4091"}],"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=4091"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4091\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}