{"id":2224,"date":"2023-07-23T04:46:32","date_gmt":"2023-07-23T04:46:32","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/"},"modified":"2023-07-23T04:46:32","modified_gmt":"2023-07-23T04:46:32","slug":"google-sheet-menanyakan-beberapa-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/","title":{"rendered":"Kueri google spreadsheet: cara menggunakan beberapa kriteria dalam kueri"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan operator <strong>AND<\/strong> dan <strong>OR<\/strong> untuk menanyakan Google Spreadsheet dengan beberapa kriteria.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Contoh operator AND:<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2:C10<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\" style=\"color: #008000;\">\"select A, B, C where A contains 'Hello' and C &gt; 10\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Contoh operator OR:<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2:C10<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\" style=\"color: #008000;\">\"select A, B, C where A contains 'Hey' or C = 10\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing operator dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Kueri Google Spreadsheet menggunakan operator AND<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20372 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiplecrit1.png\" alt=\"\" width=\"587\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kueri berikut untuk mengambil tim yang berada di Wilayah Timur <strong>dan<\/strong> telah mencetak lebih dari 90 poin:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2:D11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\" style=\"color: #008000;\">\"select A, B, C, D where B contains 'East' and C &gt; 90\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/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=\" wp-image-20373 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiplecrit2.png\" alt=\"\" width=\"662\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Magic dan Heat dipilih karena mereka adalah dua tim yang <strong>memenuhi kedua kriteria<\/strong> yang ditentukan dalam kueri kami.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Kueri Google Spreadsheet menggunakan operator OR<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita asumsikan lagi bahwa kita memiliki kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20372 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiplecrit1.png\" alt=\"\" width=\"587\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kueri berikut untuk mengambil tim yang berada di Wilayah Timur <b>atau<\/b> telah mencetak lebih dari 90 poin:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2:D11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\" style=\"color: #008000;\">\"select A, B, C, D where B contains 'East' or C &gt; 90\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/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=\" wp-image-20374 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiplecrit3.png\" alt=\"\" width=\"646\" height=\"552\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap tim yang dipilih <strong>menetapkan setidaknya satu kriteria<\/strong> yang ditentukan dalam permintaan kami.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan kata lain, setiap tim yang dipilih termasuk dalam konferensi \u201cTimur\u201d <em>atau<\/em> mencetak lebih dari 90 poin.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya dengan kueri Google Sheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kueri-google-sheet-pilih-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: cara memilih beberapa kolom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: pilih baris yang berisi string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/referensi-sel-kueri-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara menggunakan referensi sel dalam rumus<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan operator AND dan OR untuk menanyakan Google Spreadsheet dengan beberapa kriteria. Contoh operator AND: = QUERY ( A2:C10 , &#8220;select A, B, C where A contains &#8216;Hello&#8217; and C &gt; 10&#8221; ) Contoh operator OR: = QUERY ( A2:C10 , &#8220;select A, B, C where A contains &#8216;Hey&#8217; or C = 10&#8221; [&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>Kueri Google Spreadsheet: Cara menggunakan beberapa kriteria dalam kueri - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan query Google Sheets dengan beberapa kriteria, dengan beberapa 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-sheet-menanyakan-beberapa-kriteria\/\" \/>\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 beberapa kriteria dalam kueri - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan query Google Sheets dengan beberapa kriteria, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T04:46:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiplecrit1.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\/google-sheet-menanyakan-beberapa-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/\",\"name\":\"Kueri Google Spreadsheet: Cara menggunakan beberapa kriteria dalam kueri - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T04:46:32+00:00\",\"dateModified\":\"2023-07-23T04:46:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan query Google Sheets dengan beberapa kriteria, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara menggunakan beberapa kriteria dalam kueri\"}]},{\"@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 beberapa kriteria dalam kueri - Statologi","description":"Tutorial ini menjelaskan cara menggunakan query Google Sheets dengan beberapa kriteria, dengan beberapa 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-sheet-menanyakan-beberapa-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara menggunakan beberapa kriteria dalam kueri - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan query Google Sheets dengan beberapa kriteria, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-23T04:46:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiplecrit1.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\/google-sheet-menanyakan-beberapa-kriteria\/","url":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/","name":"Kueri Google Spreadsheet: Cara menggunakan beberapa kriteria dalam kueri - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T04:46:32+00:00","dateModified":"2023-07-23T04:46:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan query Google Sheets dengan beberapa kriteria, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara menggunakan beberapa kriteria dalam kueri"}]},{"@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\/2224"}],"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=2224"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2224\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}