{"id":2223,"date":"2023-07-23T04:50:14","date_gmt":"2023-07-23T04:50:14","guid":{"rendered":"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/"},"modified":"2023-07-23T04:50:14","modified_gmt":"2023-07-23T04:50:14","slug":"referensi-sel-kueri-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/","title":{"rendered":"Kueri google spreadsheet: cara menggunakan referensi sel dalam rumus"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menggunakan referensi sel dalam kueri Google Spreadsheet:<\/span><\/p>\n

 =<\/span> QUERY<\/span> (<\/span> $A$1:$B$11<\/span> ,<\/span> \"Select B where A contains '\"<\/span><\/span> &<\/span> D3<\/span> &<\/span> \"'\"<\/span> )<\/span>\n<\/strong><\/pre>\n
 Dalam kueri khusus ini, kami meminta Google Sheets untuk memilih nilai di kolom B dimana kolom A berisi nilai sel D3<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Gunakan referensi sel dalam kueri Google Spreadsheet<\/strong><\/span><\/h3>\n
 Katakanlah kita memiliki dua kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang misalkan kita ingin menambahkan kolom “poin” di sebelah kanan kolom “assist”, yang berisi poin yang dicetak oleh masing-masing tim di kolom D.<\/span><\/p>\n
 Kita dapat menggunakan sintaks berikut untuk melakukan ini:<\/span><\/p>\n
 =<\/span> QUERY<\/span> (<\/span> $A$1:$B$11<\/span> ,<\/span> \"Select B where A contains '\"<\/span><\/span> &<\/span> D3<\/span> &<\/span> \"'\"<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini di sel F2 lembar kerja kita:<\/span> <\/p>\n
\"\"<\/p>\n
 Dalam contoh ini, kami meminta Google Sheets untuk memilih nilai di kolom B<\/strong> dimana kolom A<\/strong> berisi nama tim di sel D2<\/strong> .<\/span><\/p>\n
 Dalam hal ini, dia melihat bahwa D2<\/strong> berisi “Hornet”, jadi dia mengembalikan nilai “poin” untuk Hornet, yang ternyata adalah 78.<\/span><\/p>\n
 Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom F:<\/span> <\/p>\n
\"\"<\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan kueri umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Kueri Google Spreadsheet: cara memilih beberapa kolom<\/a>
 Kueri Google Spreadsheet: pilih baris yang berisi string<\/a>
 Google Spreadsheet: cara melakukan kueri dari sheet lain<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menggunakan referensi sel dalam kueri Google Spreadsheet: = QUERY ( $A$1:$B$11 , “Select B where A contains ‘” & D3 & “‘” ) Dalam kueri khusus ini, kami meminta Google Sheets untuk memilih nilai di kolom B dimana kolom A berisi nilai sel D3 . Contoh berikut menunjukkan […]<\/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":"\nKueri Google Spreadsheet: Cara menggunakan referensi sel dalam rumus - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan referensi sel 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\/referensi-sel-kueri-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kueri Google Spreadsheet: Cara menggunakan referensi sel dalam rumus - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan referensi sel dalam kueri Google Spreadsheet, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T04:50:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cellule1.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\/referensi-sel-kueri-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/\",\"name\":\"Kueri Google Spreadsheet: Cara menggunakan referensi sel dalam rumus - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T04:50:14+00:00\",\"dateModified\":\"2023-07-23T04:50:14+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan referensi sel dalam kueri Google Spreadsheet, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara menggunakan referensi sel dalam rumus\"}]},{\"@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":"Kueri Google Spreadsheet: Cara menggunakan referensi sel dalam rumus - Statologi","description":"Tutorial ini menjelaskan cara menggunakan referensi sel 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\/referensi-sel-kueri-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara menggunakan referensi sel dalam rumus - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan referensi sel dalam kueri Google Spreadsheet, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-23T04:50:14+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cellule1.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\/referensi-sel-kueri-google-sheet\/","url":"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/","name":"Kueri Google Spreadsheet: Cara menggunakan referensi sel dalam rumus - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T04:50:14+00:00","dateModified":"2023-07-23T04:50:14+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan referensi sel dalam kueri Google Spreadsheet, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara menggunakan referensi sel dalam rumus"}]},{"@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\/2223"}],"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=2223"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2223\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}