{"id":3264,"date":"2023-07-18T09:43:55","date_gmt":"2023-07-18T09:43:55","guid":{"rendered":"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/"},"modified":"2023-07-18T09:43:55","modified_gmt":"2023-07-18T09:43:55","slug":"permintaan-google-sheet-abaikan-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/","title":{"rendered":"Kueri google spreadsheet: cara mengabaikan sel kosong di kueri"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk mengabaikan sel kosong di kolom tertentu saat menjalankan kueri Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Abaikan Sel Kosong di Kolom<\/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 B is not null\"<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Abaikan sel kosong di beberapa kolom<\/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 B is not null and C is not null\"<\/span> )<\/strong><\/pre>\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-27670 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorerblank11.jpg\" alt=\"\" width=\"480\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Baris Kueri dan Abaikan Spasi Kosong di Kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk memilih semua baris yang kolom <b>Poinnya<\/b> tidak kosong:<\/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 B is not null\"<\/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-27671\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorerblank12.jpg\" alt=\"Kueri Google Spreadsheet mengabaikan sel kosong\" width=\"676\" height=\"454\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya baris yang kolom <strong>Poinnya<\/strong> tidak kosong yang dikembalikan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Kueri baris dan abaikan spasi di beberapa kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk memilih semua baris dimana kolom <b>Poin<\/b> <em>dan<\/em> kolom <strong>Bantuan<\/strong> tidak kosong:<\/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 B is not null and C is not null\"<\/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-27672 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorerblank13.jpg\" alt=\"\" width=\"672\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa kueri ini hanya mengembalikan baris yang kolom <b>Poin<\/b> <em>dan<\/em> <strong>Bantuannya<\/strong> tidak kosong:<\/span><\/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 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 mengabaikan sel kosong di kolom tertentu saat menjalankan kueri Google Spreadsheet: Metode 1: Abaikan Sel Kosong di Kolom =QUERY( A1:C11 , &#8220;select * where B is not null&#8221; ) Metode 2: Abaikan sel kosong di beberapa kolom =QUERY( A1:C11 , &#8220;select * where B is not null and C [&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 mengabaikan sel kosong dalam kueri - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengabaikan sel kosong di 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-abaikan-kosong\/\" \/>\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 mengabaikan sel kosong dalam kueri - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengabaikan sel kosong di kueri Google Spreadsheet, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T09:43:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorerblank11.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-abaikan-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/\",\"name\":\"Kueri Google Spreadsheet: Cara mengabaikan sel kosong dalam kueri - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T09:43:55+00:00\",\"dateModified\":\"2023-07-18T09:43:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengabaikan sel kosong di kueri Google Spreadsheet, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara mengabaikan sel kosong di 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 mengabaikan sel kosong dalam kueri - Statorial","description":"Tutorial ini menjelaskan cara mengabaikan sel kosong di 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-abaikan-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara mengabaikan sel kosong dalam kueri - Statorial","og_description":"Tutorial ini menjelaskan cara mengabaikan sel kosong di kueri Google Spreadsheet, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-18T09:43:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorerblank11.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-abaikan-kosong\/","url":"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/","name":"Kueri Google Spreadsheet: Cara mengabaikan sel kosong dalam kueri - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T09:43:55+00:00","dateModified":"2023-07-18T09:43:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengabaikan sel kosong di kueri Google Spreadsheet, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara mengabaikan sel kosong di 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\/3264"}],"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=3264"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3264\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}