{"id":2722,"date":"2023-07-21T00:27:11","date_gmt":"2023-07-21T00:27:11","guid":{"rendered":"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/"},"modified":"2023-07-21T00:27:11","modified_gmt":"2023-07-21T00:27:11","slug":"bulan-permintaan-google-sheets","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/","title":{"rendered":"Google spreadsheet: cara melakukan kueri menggunakan bulan"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menemukan baris di Google Spreadsheet yang berisi bulan tertentu di kolom tanggal:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span style=\"color: #ff6600;\">A1:C13<\/span> , \" <span style=\"color: #008000;\">select A,B,C where month(A)+1=2<\/span> \", <span style=\"color: #3366ff;\">1<\/span> )<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri khusus ini mengembalikan nilai dari kolom <strong>A<\/strong> , <strong>B<\/strong> , dan <strong>C<\/strong> dalam rentang <strong>A1:C13<\/strong> dengan tanggal di kolom A adalah <strong>2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <strong>2<\/strong> mewakili nomor bulan, yaitu Februari.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menemukan baris dengan tanggal berisi Januari, gunakan <strong>1<\/strong> . Untuk bulan Desember, gunakan <strong>12<\/strong> . Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Kueri yang tanggalnya berisi bulan tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan kueri berikut untuk mengembalikan semua baris yang bulannya di kolom <strong>A<\/strong> berisi Februari:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span style=\"color: #ff6600;\">A1:C13<\/span> , \" <span style=\"color: #008000;\">select A,B,C where month(A)+1=2<\/span> \", <span style=\"color: #3366ff;\">1<\/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-23973\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/requetemois1-1.jpg\" alt=\"Bulan Kueri Google Spreadsheet\" width=\"607\" height=\"556\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa empat baris yang dikembalikan oleh kueri semuanya berisi bulan Februari di kolom <strong>A.<\/strong><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Kueri yang tanggalnya berisi salah satu dari beberapa bulan tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan kueri berikut untuk mengembalikan semua baris yang bulannya di kolom <strong>A<\/strong> berisi Februari <em>atau<\/em> April:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span style=\"color: #ff6600;\">A1:C13<\/span> , \" <span style=\"color: #008000;\">select A,B,C where month(A)+1=2 or month(A)+1=4<\/span> \", <span style=\"color: #3366ff;\">1<\/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=\" wp-image-23974 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/requetemois2.jpg\" alt=\"\" width=\"671\" height=\"571\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa semua baris yang dikembalikan oleh kueri berisi bulan Februari atau April di kolom <strong>A.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda menerima kesalahan saat menggunakan rumus ini, pastikan nilai di kolom A dalam format <strong>Tanggal<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengonversi nilai di kolom A ke format Tanggal, cukup sorot kolom A, lalu klik <strong>Format<\/strong> di sepanjang pita atas, lalu klik <strong>Nomor<\/strong> , lalu <strong>Tanggal<\/strong> .<\/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 di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menambahkan-bulan-hingga-saat-ini\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan bulan hingga saat ini di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan data berdasarkan bulan di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Konversi antara nama bulan dan nomor di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk menemukan baris di Google Spreadsheet yang berisi bulan tertentu di kolom tanggal: =QUERY( A1:C13 , &#8221; select A,B,C where month(A)+1=2 &#8220;, 1 ) Kueri khusus ini mengembalikan nilai dari kolom A , B , dan C dalam rentang A1:C13 dengan tanggal di kolom A adalah 2 . Perhatikan bahwa [&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>Google Spreadsheet: Cara Membuat Kueri Menggunakan Bulan - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter data di Google Sheets berdasarkan bulan, beserta contohnya.\" \/>\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\/bulan-permintaan-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara Membuat Kueri Menggunakan Bulan - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter data di Google Sheets berdasarkan bulan, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T00:27:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/requetemois1-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\/bulan-permintaan-google-sheets\/\",\"url\":\"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/\",\"name\":\"Google Spreadsheet: Cara Membuat Kueri Menggunakan Bulan - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T00:27:11+00:00\",\"dateModified\":\"2023-07-21T00:27:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter data di Google Sheets berdasarkan bulan, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara melakukan kueri menggunakan bulan\"}]},{\"@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":"Google Spreadsheet: Cara Membuat Kueri Menggunakan Bulan - Statologi","description":"Tutorial ini menjelaskan cara memfilter data di Google Sheets berdasarkan bulan, beserta contohnya.","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\/bulan-permintaan-google-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara Membuat Kueri Menggunakan Bulan - Statologi","og_description":"Tutorial ini menjelaskan cara memfilter data di Google Sheets berdasarkan bulan, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/","og_site_name":"Statorials","article_published_time":"2023-07-21T00:27:11+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/requetemois1-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\/bulan-permintaan-google-sheets\/","url":"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/","name":"Google Spreadsheet: Cara Membuat Kueri Menggunakan Bulan - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T00:27:11+00:00","dateModified":"2023-07-21T00:27:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter data di Google Sheets berdasarkan bulan, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bulan-permintaan-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara melakukan kueri menggunakan bulan"}]},{"@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\/2722"}],"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=2722"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2722\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}