{"id":2845,"date":"2023-07-20T10:53:29","date_gmt":"2023-07-20T10:53:29","guid":{"rendered":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/"},"modified":"2023-07-20T10:53:29","modified_gmt":"2023-07-20T10:53:29","slug":"urutkan-berdasarkan-tanggal-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/","title":{"rendered":"Cara mengurutkan berdasarkan tanggal di google sheets (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Cara termudah untuk mengurutkan berdasarkan tanggal di Google Sheets adalah dengan menggunakan fitur <strong>Sortir berdasarkan Rentang<\/strong> di tab <strong>Data<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Mari kita mulai dengan memasukkan kumpulan nilai tanggal berikut ke dalam Google Spreadsheet:<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24925 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri1-1.jpg\" alt=\"\" width=\"490\" height=\"449\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Verifikasi bahwa data dalam format tanggal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Jika nilai data Anda tidak dalam format tanggal, Anda tidak akan dapat mengurutkannya dengan benar.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memverifikasi bahwa nilai-nilai dalam format tanggal, pastikan semua nilai <strong>rata kanan<\/strong> dalam sel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada tangkapan layar berikut, beberapa nilai rata kiri, artinya tidak dalam format tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24926 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri2-1.jpg\" alt=\"\" width=\"489\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Untuk mengonversi setiap nilai dalam kolom ke format tanggal, cukup sorot semua nilai di kolom, lalu klik tab <strong>Format<\/strong> , lalu <strong>Angka<\/strong> , lalu <strong>Tanggal<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Masing-masing nilai sekarang harus disejajarkan dengan benar.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Urutkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mengurutkan nilai tanggal, sorot rentang <strong>A2:A12<\/strong> lalu klik tab <strong>Data<\/strong> , lalu klik <strong>Urutkan Rentang<\/strong> , lalu klik <strong>Urutkan Rentang berdasarkan Kolom A (A hingga Z)<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24927\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri3-1.jpg\" alt=\"urutkan berdasarkan tanggal di Google Spreadsheet\" width=\"678\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tanggal akan secara otomatis diurutkan dari tanggal terlama hingga tanggal terbaru:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24928 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri4.jpg\" alt=\"\" width=\"490\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda mengklik <strong>Urutkan Rentang menurut Kolom A (Z ke A)<\/strong> , tanggal akan diurutkan dari tanggal terbaru hingga tanggal terlama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24929 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri5.jpg\" alt=\"\" width=\"480\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memberi-peringkat-pada-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara mengurutkan item di beberapa kolom di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mengklasifikasikan-jika-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan rumus RANK IF di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-teratas-10-persen\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan nilai 10% teratas di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara termudah untuk mengurutkan berdasarkan tanggal di Google Sheets adalah dengan menggunakan fitur Sortir berdasarkan Rentang di tab Data . Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan kumpulan nilai tanggal berikut ke dalam Google Spreadsheet: Langkah 2: Verifikasi bahwa data dalam [&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>Cara Mengurutkan Berdasarkan Tanggal di Google Sheets (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan berdasarkan tanggal di Google Sheets, dengan sebuah 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\/urutkan-berdasarkan-tanggal-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengurutkan Berdasarkan Tanggal di Google Sheets (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan berdasarkan tanggal di Google Sheets, dengan sebuah contoh\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T10:53:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri1-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\/urutkan-berdasarkan-tanggal-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/\",\"name\":\"Cara Mengurutkan Berdasarkan Tanggal di Google Sheets (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T10:53:29+00:00\",\"dateModified\":\"2023-07-20T10:53:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan berdasarkan tanggal di Google Sheets, dengan sebuah contoh\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengurutkan berdasarkan tanggal di google sheets (dengan contoh)\"}]},{\"@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":"Cara Mengurutkan Berdasarkan Tanggal di Google Sheets (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengurutkan berdasarkan tanggal di Google Sheets, dengan sebuah 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\/urutkan-berdasarkan-tanggal-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengurutkan Berdasarkan Tanggal di Google Sheets (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengurutkan berdasarkan tanggal di Google Sheets, dengan sebuah contoh","og_url":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-20T10:53:29+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri1-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\/urutkan-berdasarkan-tanggal-google-sheet\/","url":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/","name":"Cara Mengurutkan Berdasarkan Tanggal di Google Sheets (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T10:53:29+00:00","dateModified":"2023-07-20T10:53:29+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan berdasarkan tanggal di Google Sheets, dengan sebuah contoh","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengurutkan berdasarkan tanggal di google sheets (dengan contoh)"}]},{"@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\/2845"}],"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=2845"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2845\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}