{"id":4019,"date":"2023-07-14T03:26:28","date_gmt":"2023-07-14T03:26:28","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/"},"modified":"2023-07-14T03:26:28","modified_gmt":"2023-07-14T03:26:28","slug":"google-sheets-menanyakan-beberapa-rentang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/","title":{"rendered":"Google spreadsheet: cara melakukan kueri dari berbagai rentang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menanyakan beberapa rentang di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=QUERY({ <span style=\"color: #ff6600;\">Sheet1!A1:B10<\/span> ; <span style=\"color: #800080;\">Sheet2!A2:B5<\/span> })\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan mengembalikan sel dalam rentang <strong>A1:B10<\/strong> dari <strong>Sheet1<\/strong> yang ditumpuk di atas sel dalam rentang <strong>A2:B5<\/strong> dari <strong>Sheet2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Kueri dari beberapa rentang di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki data berikut di <strong>Sheet1<\/strong> dan <strong>Sheet2<\/strong> di Google Sheets yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32129 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/q1.jpg\" alt=\"\" width=\"473\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32130 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/q2.jpg\" alt=\"\" width=\"472\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menanyakan data dari kedua sheet dan menempatkan hasilnya di sheet baru bernama <strong>Sheet3<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=QUERY({ <span style=\"color: #ff6600;\">Sheet1!A1:B10<\/span> ; <span style=\"color: #800080;\">Sheet2!A2:B5<\/span> })<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menggunakan rumus tersebut dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32131\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/q3.jpg\" alt=\"Kueri Google Spreadsheet dari berbagai rentang\" width=\"539\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris-baris di <b>Sheet1<\/b> hanya ditumpuk di atas baris-baris di <strong>Sheet2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin baris <strong>Sheet2<\/strong> ditempatkan di sebelah baris <strong>Sheet1<\/strong> , Anda bisa menggunakan koma dalam rumus dan bukan titik koma:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=QUERY({ <span style=\"color: #ff6600;\">Sheet1!A1:B10<\/span> , <span style=\"color: #800080;\">Sheet2!A1:B10<\/span> })<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menggunakan rumus tersebut dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32132 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/q4.jpg\" alt=\"\" width=\"541\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris dari <strong>Sheet2<\/strong> sekarang ditempatkan di sebelah baris dari <strong>Sheet1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam contoh ini, kami hanya menggunakan dua rentang sel, namun Anda dapat menggunakan sintaks serupa untuk menanyakan rentang sel sebanyak yang Anda inginkan.<\/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 kueri umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kueri-google-sheet-pilih-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara memilih beberapa kolom dalam kueri<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara melakukan kueri dari sheet lain<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara menggunakan Grup Berdasarkan dalam kueri<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara menggunakan Pesan Berdasarkan dalam kueri<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menanyakan beberapa rentang di Google Spreadsheet: =QUERY({ Sheet1!A1:B10 ; Sheet2!A2:B5 }) Contoh khusus ini akan mengembalikan sel dalam rentang A1:B10 dari Sheet1 yang ditumpuk di atas sel dalam rentang A2:B5 dari Sheet2 . Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Kueri dari beberapa rentang di [&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 melakukan kueri dari berbagai rentang \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menanyakan beberapa rentang 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\/google-sheets-menanyakan-beberapa-rentang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara melakukan kueri dari berbagai rentang \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menanyakan beberapa rentang di Google Spreadsheet, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T03:26:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/q1.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\/google-sheets-menanyakan-beberapa-rentang\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/\",\"name\":\"Google Spreadsheet: Cara melakukan kueri dari berbagai rentang \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T03:26:28+00:00\",\"dateModified\":\"2023-07-14T03:26:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menanyakan beberapa rentang di Google Spreadsheet, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara melakukan kueri dari berbagai rentang\"}]},{\"@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 melakukan kueri dari berbagai rentang \u2013 Statologi","description":"Tutorial ini menjelaskan cara menanyakan beberapa rentang 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\/google-sheets-menanyakan-beberapa-rentang\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara melakukan kueri dari berbagai rentang \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menanyakan beberapa rentang di Google Spreadsheet, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/","og_site_name":"Statorials","article_published_time":"2023-07-14T03:26:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/q1.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\/google-sheets-menanyakan-beberapa-rentang\/","url":"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/","name":"Google Spreadsheet: Cara melakukan kueri dari berbagai rentang \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T03:26:28+00:00","dateModified":"2023-07-14T03:26:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menanyakan beberapa rentang di Google Spreadsheet, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheets-menanyakan-beberapa-rentang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara melakukan kueri dari berbagai rentang"}]},{"@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\/4019"}],"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=4019"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4019\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4019"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4019"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}