{"id":2747,"date":"2023-07-20T21:39:45","date_gmt":"2023-07-20T21:39:45","guid":{"rendered":"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/"},"modified":"2023-07-20T21:39:45","modified_gmt":"2023-07-20T21:39:45","slug":"permintaan-google-sheet-tidak-sama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/","title":{"rendered":"Permintaan google sheets: bagaimana cara menggunakan &quot;tidak sama&quot;? dalam kueri"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk menggunakan operator &#8220;berbeda&#8221; dalam kueri Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Tidak sama dengan nilai tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=query( <span style=\"color: #ff6600;\">A1:C11<\/span> , \" <span style=\"color: #008000;\">select * where A != 'Value1'<\/span> \")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Tidak sama dengan salah satu dari beberapa nilai<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=query( <span style=\"color: #ff6600;\">A1:C11<\/span> , \" <span style=\"color: #008000;\">select * where A != 'Value1' and B != 'Value2'<\/span> \")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <strong>!=<\/strong> adalah operator &#8220;berbeda&#8221; di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24182 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noteegal1-1.jpg\" alt=\"\" width=\"460\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Baris kueri tidak sama dengan nilai tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk memilih semua baris yang kolom <strong>Posisinya<\/strong> tidak sama dengan &#8220;Penjaga&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=query( <span style=\"color: #ff6600;\">A1:C11<\/span> , \" <span style=\"color: #008000;\">select * where A != 'Guard'<\/span> \")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24183\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noteegal2-1.jpg\" alt=\"Permintaan Google Sheets tidak sama\" width=\"677\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya baris yang Posisinya tidak sama dengan \u201cKeep\u201d yang dikembalikan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Baris kueri tidak sama dengan salah satu dari beberapa nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk memilih semua baris dimana kolom <strong>Posisi<\/strong> tidak sama dengan &#8220;Penjaga&#8221; dan kolom <strong>Tim<\/strong> tidak sama dengan &#8220;Prajurit&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=query( <span style=\"color: #ff6600;\">A1:C11<\/span> , \" <span style=\"color: #008000;\">select * where A != 'Guard' and B != 'Warriors'<\/span> \")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24184 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noteegal3-1.jpg\" alt=\"\" width=\"676\" height=\"390\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya garis yang <strong>posisinya<\/strong> tidak sama dengan &#8220;Penjaga&#8221; dan <strong>tim<\/strong> tidak sama dengan &#8220;Prajurit&#8221; yang dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Fungsi <strong>query()<\/strong> peka huruf besar-kecil. Artinya, jika Anda mengetik <strong>A != &#8216;guard&#8217;<\/strong> , kueri akan selalu mengembalikan baris dengan Position adalah Guard karena kedua nilai tersebut bukan huruf besar\/kecil.<\/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 Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara Membuat Kueri dari Sheet Lain<\/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\/grup-kueri-google-sheet-menurut\/\">Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara Menggunakan Sortir Berdasarkan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk menggunakan operator &#8220;berbeda&#8221; dalam kueri Google Spreadsheet: Metode 1: Tidak sama dengan nilai tertentu =query( A1:C11 , &#8221; select * where A != &#8216;Value1&#8217; &#8220;) Metode 2: Tidak sama dengan salah satu dari beberapa nilai =query( A1:C11 , &#8221; select * where A != &#8216;Value1&#8217; and B != &#8216;Value2&#8217; [&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 \u201cTidak Sama\u201d dalam kueri \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berbeda&quot; dalam kueri Google Spreadsheet, 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\/permintaan-google-sheet-tidak-sama\/\" \/>\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 \u201cTidak Sama\u201d dalam kueri \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berbeda&quot; dalam kueri Google Spreadsheet, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T21:39:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noteegal1-1.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\/permintaan-google-sheet-tidak-sama\/\",\"url\":\"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/\",\"name\":\"Kueri Google Spreadsheet: Cara menggunakan \u201cTidak Sama\u201d dalam kueri \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T21:39:45+00:00\",\"dateModified\":\"2023-07-20T21:39:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berbeda&quot; dalam kueri Google Spreadsheet, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Permintaan google sheets: bagaimana cara menggunakan &quot;tidak sama&quot;? 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 \u201cTidak Sama\u201d dalam kueri \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berbeda&quot; dalam kueri Google Spreadsheet, 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\/permintaan-google-sheet-tidak-sama\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara menggunakan \u201cTidak Sama\u201d dalam kueri \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berbeda&quot; dalam kueri Google Spreadsheet, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/","og_site_name":"Statorials","article_published_time":"2023-07-20T21:39:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noteegal1-1.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\/permintaan-google-sheet-tidak-sama\/","url":"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/","name":"Kueri Google Spreadsheet: Cara menggunakan \u201cTidak Sama\u201d dalam kueri \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T21:39:45+00:00","dateModified":"2023-07-20T21:39:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan pernyataan &quot;berbeda&quot; dalam kueri Google Spreadsheet, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/permintaan-google-sheet-tidak-sama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Permintaan google sheets: bagaimana cara menggunakan &quot;tidak sama&quot;? 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\/2747"}],"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=2747"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2747\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}