{"id":4190,"date":"2023-07-12T23:44:31","date_gmt":"2023-07-12T23:44:31","guid":{"rendered":"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/"},"modified":"2023-07-12T23:44:31","modified_gmt":"2023-07-12T23:44:31","slug":"rentang-tanggal-filter-muka-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/","title":{"rendered":"Filter tingkat lanjut excel: cara memfilter menggunakan rentang tanggal"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>Filter Tingkat Lanjut<\/strong> di Excel untuk memfilter baris dalam kumpulan data berdasarkan rentang tanggal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan rentang tanggal di filter lanjutan Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang menunjukkan total penjualan yang dilakukan pada tanggal berbeda oleh sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33167 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avance1.jpg\" alt=\"\" width=\"449\" height=\"475\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin memfilter baris dengan tanggal antara 20\/01\/2023 dan 20\/02\/2023.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan hal ini, kita dapat menentukan rentang kriteria dengan dua tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33168 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avance2.jpg\" alt=\"\" width=\"479\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita bisa klik pada tab <strong>Data<\/strong> , lalu klik tombol <strong>Advanced Filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33169 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avance3.jpg\" alt=\"\" width=\"529\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita akan memilih <strong>A1:B11<\/strong> sebagai <strong>rentang daftar<\/strong> dan <strong>D1:E2<\/strong> sebagai <strong>rentang kriteria<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33170 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avance4.jpg\" alt=\"\" width=\"559\" height=\"528\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita mengklik <strong>OK<\/strong> , kumpulan data akan difilter untuk hanya menampilkan baris dengan tanggal antara 20\/01\/2023 dan 20\/02\/2023:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33171 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avance5.jpg\" alt=\"\" width=\"448\" height=\"397\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa setiap tanggal dalam data yang difilter adalah antara 20\/01\/2023 dan 20\/02\/2023.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda ingin memfilter baris untuk menyertakan tanggal mulai dan akhir, Anda dapat menggunakan operator <strong>&gt;=<\/strong> dan <strong>&lt;=<\/strong> dalam rentang kriteria, bukan operator <strong>&gt;<\/strong> dan <strong>&lt;<\/strong> .<\/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 di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/\" target=\"_blank\" rel=\"noopener\">Filter Tingkat Lanjut Excel: Cara Menggunakan \u201cTidak Berisi\u201d<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/\" target=\"_blank\" rel=\"noopener\">Filter lanjutan Excel: cara menggunakan &#8220;Berisi&#8221;<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/muka-filter-excel-tidak-kosong\/\" target=\"_blank\" rel=\"noopener\">Filter lanjutan Excel: menampilkan baris dengan nilai yang tidak kosong<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi Filter Tingkat Lanjut di Excel untuk memfilter baris dalam kumpulan data berdasarkan rentang tanggal. Contoh berikut menunjukkan cara melakukan hal ini. Contoh: Cara menggunakan rentang tanggal di filter lanjutan Excel Misalkan kita mempunyai kumpulan data berikut yang menunjukkan total penjualan yang dilakukan pada tanggal berbeda oleh sebuah perusahaan: Sekarang katakanlah kita [&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>Filter Tingkat Lanjut Excel: Cara Memfilter Menggunakan Rentang Tanggal - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan Filter Tingkat Lanjut Excel untuk memfilter baris menggunakan rentang tanggal, 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\/rentang-tanggal-filter-muka-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Filter Tingkat Lanjut Excel: Cara Memfilter Menggunakan Rentang Tanggal - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan Filter Tingkat Lanjut Excel untuk memfilter baris menggunakan rentang tanggal, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T23:44:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avance1.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\/rentang-tanggal-filter-muka-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/\",\"name\":\"Filter Tingkat Lanjut Excel: Cara Memfilter Menggunakan Rentang Tanggal - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T23:44:31+00:00\",\"dateModified\":\"2023-07-12T23:44:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan Filter Tingkat Lanjut Excel untuk memfilter baris menggunakan rentang tanggal, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Filter tingkat lanjut excel: cara memfilter menggunakan rentang tanggal\"}]},{\"@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":"Filter Tingkat Lanjut Excel: Cara Memfilter Menggunakan Rentang Tanggal - Statorials","description":"Tutorial ini menjelaskan cara menggunakan Filter Tingkat Lanjut Excel untuk memfilter baris menggunakan rentang tanggal, 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\/rentang-tanggal-filter-muka-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Filter Tingkat Lanjut Excel: Cara Memfilter Menggunakan Rentang Tanggal - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan Filter Tingkat Lanjut Excel untuk memfilter baris menggunakan rentang tanggal, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-12T23:44:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avance1.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\/rentang-tanggal-filter-muka-excel\/","url":"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/","name":"Filter Tingkat Lanjut Excel: Cara Memfilter Menggunakan Rentang Tanggal - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T23:44:31+00:00","dateModified":"2023-07-12T23:44:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan Filter Tingkat Lanjut Excel untuk memfilter baris menggunakan rentang tanggal, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rentang-tanggal-filter-muka-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Filter tingkat lanjut excel: cara memfilter menggunakan rentang tanggal"}]},{"@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\/4190"}],"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=4190"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4190\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}