{"id":1435,"date":"2023-07-26T10:01:41","date_gmt":"2023-07-26T10:01:41","guid":{"rendered":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/"},"modified":"2023-07-26T10:01:41","modified_gmt":"2023-07-26T10:01:41","slug":"urutkan-berdasarkan-beberapa-kolom-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/","title":{"rendered":"Cara mengurutkan berdasarkan beberapa kolom di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin mengurutkan beberapa kolom di Excel. Untungnya, hal ini mudah dilakukan dengan menggunakan opsi <strong>Custom Sort<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14194 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple3.png\" alt=\"\" width=\"645\" height=\"358\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara menggunakan penyortiran khusus dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data palsu untuk digunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14192 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple1.png\" alt=\"\" width=\"466\" height=\"511\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Urutkan pada beberapa kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan mengurutkan datanya sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pertama, urutkan berdasarkan <strong>ukuran rumah tangga,<\/strong> dari yang terbesar hingga yang terkecil.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemudian urutkan berdasarkan <strong>nama belakang<\/strong> dari A sampai Z.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, sorot setiap kolom termasuk header:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14193 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple2.png\" alt=\"\" width=\"519\" height=\"553\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik opsi <strong>Sortir &amp; Filter<\/strong> di bagian <strong>Pengeditan<\/strong> pada tab <strong>Beranda<\/strong> . Di menu tarik-turun, klik <strong>Penyortiran Khusus<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14194 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple3.png\" alt=\"\" width=\"645\" height=\"358\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul, urutkan berdasarkan <strong>ukuran rumah tangga<\/strong> dan pilih <strong>dari yang terbesar hingga terkecil<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya klik <strong>Tambah Level<\/strong> di pojok kiri atas, urutkan berdasarkan <strong>nama belakang<\/strong> dan pilih <strong>A hingga Z.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14195 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple4.png\" alt=\"Urutkan pada beberapa kolom di Excel\" width=\"616\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , data akan diurutkan secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14196 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple5.png\" alt=\"Menyortir beberapa kolom di Excel\" width=\"458\" height=\"557\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris-baris tersebut diurutkan berdasarkan <strong>ukuran rumah tangga<\/strong> , dari yang terbesar hingga yang terkecil, itulah sebabnya ukuran rumah tangga 7 muncul terlebih dahulu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu kita urutkan berdasarkan <strong>nama belakang<\/strong> dari A sampai Z. Artinya untuk semua rumah tangga dengan ukuran yang sama, kita menentukan urutannya dengan mengurutkan dari A sampai Z.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, setiap rumah tangga yang beranggotakan 4 orang diurutkan dari A sampai Z:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14197 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple6.png\" alt=\"\" width=\"471\" height=\"537\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kita mengurutkan berdasarkan dua kolom, tetapi menggunakan opsi <strong>Pengurutan Kustom<\/strong> Anda dapat mengurutkan kolom sebanyak yang Anda inginkan.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin mengurutkan beberapa kolom di Excel. Untungnya, hal ini mudah dilakukan dengan menggunakan opsi Custom Sort . Tutorial ini memberikan contoh langkah demi langkah tentang cara menggunakan penyortiran khusus dalam praktiknya. Langkah 1: Buat datanya Pertama, mari buat kumpulan data palsu untuk digunakan: Langkah 2: Urutkan pada beberapa kolom Selanjutnya kita akan [&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 beberapa kolom di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan beberapa kolom di Excel, termasuk contoh langkah demi langkah.\" \/>\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-beberapa-kolom-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengurutkan berdasarkan beberapa kolom di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan beberapa kolom di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T10:01:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple3.png\" \/>\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-beberapa-kolom-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/\",\"name\":\"Cara mengurutkan berdasarkan beberapa kolom di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T10:01:41+00:00\",\"dateModified\":\"2023-07-26T10:01:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan beberapa kolom di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengurutkan berdasarkan beberapa kolom di excel\"}]},{\"@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 beberapa kolom di Excel","description":"Tutorial ini menjelaskan cara mengurutkan beberapa kolom di Excel, termasuk contoh langkah demi langkah.","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-beberapa-kolom-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengurutkan berdasarkan beberapa kolom di Excel","og_description":"Tutorial ini menjelaskan cara mengurutkan beberapa kolom di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T10:01:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple3.png"}],"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-beberapa-kolom-di-excel\/","url":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/","name":"Cara mengurutkan berdasarkan beberapa kolom di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T10:01:41+00:00","dateModified":"2023-07-26T10:01:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan beberapa kolom di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengurutkan berdasarkan beberapa kolom di excel"}]},{"@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\/1435"}],"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=1435"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1435\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}