{"id":4143,"date":"2023-07-13T07:37:05","date_gmt":"2023-07-13T07:37:05","guid":{"rendered":"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/"},"modified":"2023-07-13T07:37:05","modified_gmt":"2023-07-13T07:37:05","slug":"kueri-google-sheet-bernama-rentang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/","title":{"rendered":"Cara menggunakan rentang bernama dalam kueri google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaksis berikut dalam kueri Google Spreadsheet untuk mereferensikan rentang bernama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY({ <span dir=\"auto\" style=\"color: #ff6600;\">my_named_range<\/span> }, <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">SELECT Col1, Col3 WHERE Col1 = 'value1'<\/span> \"<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri khusus ini akan memilih kolom pertama dan kolom ketiga dari rentang bernama yang disebut <strong>my_named_range<\/strong> di mana kolom pertama dari rentang bernama sama dengan &#8220;nilai1&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Rentang bernama harus diapit tanda kurung kurawal, jika tidak, Google Spreadsheet akan menimbulkan kesalahan.<\/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: Gunakan rentang bernama dalam kueri Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32910 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nomme1-1.png\" alt=\"\" width=\"548\" height=\"478\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan pada kotak Nama di sudut kiri atas bahwa rentang sel tertentu <strong>B1:D11<\/strong> diberi nama <strong>team_data<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk memilih kolom pertama dan ketiga dari rentang bernama ini yang nilai di kolom pertama sama dengan &#8220;Mavs&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY({ <span dir=\"auto\" style=\"color: #ff6600;\">team_data<\/span> }, <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">SELECT Col1, Col3 WHERE Col1 = 'Mavs'<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan kueri ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32911\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-requete2.png\" alt=\"Kueri Google Spreadsheet bernama rentang\" width=\"602\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kueri mengembalikan nilai di kolom tim dan kolom bantuan dengan nilai di kolom tim sama dengan &#8220;Mavs&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Keuntungan menggunakan rentang bernama dalam kueri kita adalah jika lokasi kumpulan data asli kita dipindahkan karena alasan apa pun, kueri akan tetap berfungsi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita menggeser semua data kita satu kolom ke kiri.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kueri kami dengan rentang bernama akan tetap berfungsi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32912 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-requete3.png\" alt=\"\" width=\"589\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Querynya mengembalikan hasil yang sama seperti contoh sebelumnya meskipun cell range kita telah digeser.<\/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\/permintaan-tunggal-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara mengembalikan baris unik saja<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: cara menghapus header dari hasil<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara Mengabaikan Sel Kosong di Kueri<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaksis berikut dalam kueri Google Spreadsheet untuk mereferensikan rentang bernama: =QUERY({ my_named_range }, &#8221; SELECT Col1, Col3 WHERE Col1 = &#8216;value1&#8217; &#8221; ) Kueri khusus ini akan memilih kolom pertama dan kolom ketiga dari rentang bernama yang disebut my_named_range di mana kolom pertama dari rentang bernama sama dengan &#8220;nilai1&#8221;. Catatan : Rentang [&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 menggunakan rentang bernama dalam kueri Google Spreadsheet \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rentang bernama dalam kueri Google Spreadsheet, beserta 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\/kueri-google-sheet-bernama-rentang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan rentang bernama dalam kueri Google Spreadsheet \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rentang bernama dalam kueri Google Spreadsheet, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T07:37:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nomme1-1.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\/kueri-google-sheet-bernama-rentang\/\",\"url\":\"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/\",\"name\":\"Cara menggunakan rentang bernama dalam kueri Google Spreadsheet \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T07:37:05+00:00\",\"dateModified\":\"2023-07-13T07:37:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rentang bernama dalam kueri Google Spreadsheet, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan rentang bernama dalam kueri 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 menggunakan rentang bernama dalam kueri Google Spreadsheet \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan rentang bernama dalam kueri Google Spreadsheet, beserta 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\/kueri-google-sheet-bernama-rentang\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan rentang bernama dalam kueri Google Spreadsheet \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan rentang bernama dalam kueri Google Spreadsheet, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/","og_site_name":"Statorials","article_published_time":"2023-07-13T07:37:05+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nomme1-1.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\/kueri-google-sheet-bernama-rentang\/","url":"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/","name":"Cara menggunakan rentang bernama dalam kueri Google Spreadsheet \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T07:37:05+00:00","dateModified":"2023-07-13T07:37:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rentang bernama dalam kueri Google Spreadsheet, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kueri-google-sheet-bernama-rentang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan rentang bernama dalam kueri 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\/4143"}],"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=4143"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4143\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}