{"id":4329,"date":"2023-07-11T23:04:42","date_gmt":"2023-07-11T23:04:42","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/"},"modified":"2023-07-11T23:04:42","modified_gmt":"2023-07-11T23:04:42","slug":"vba-mengurutkan-lembar-berdasarkan-beberapa-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/","title":{"rendered":"Vba: cara mengurutkan lembar berdasarkan beberapa kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk mengurutkan lembar Excel berdasarkan beberapa kolom menggunakan VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub <span style=\"color: #000000;\">SortMultipleColumns()\n    Range(\" <span style=\"color: #ff0000;\">A1:B11<\/span> \").Sort Key1:=Range(\" <span style=\"color: #ff0000;\">A1<\/span> \"), Order1:=xlAscending, _\n                         Key2:=Range(\" <span style=\"color: #ff0000;\">B1<\/span> \"), Order2:=xlDescending, _\n                         Header:=xlYes<\/span>\nEnd Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini mengurutkan sel dalam rentang <strong>A1:B11<\/strong> terlebih dahulu berdasarkan nilai di kolom A dalam urutan menaik, kemudian berdasarkan nilai di kolom B dalam urutan menurun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <strong>Header:=xlYes<\/strong> menetapkan bahwa baris pertama harus diperlakukan sebagai baris header.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Mengurutkan Lembar Excel berdasarkan Beberapa Kolom Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34026 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbasort1.jpg\" alt=\"\" width=\"472\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengurutkan dataset dengan cara berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pertama, urutkan berdasarkan nilai pada kolom <strong>Tim<\/strong> dalam urutan menaik (A sampai Z).<\/span><\/li>\n<li> <span style=\"color: #000000;\">Selanjutnya urutkan berdasarkan nilai pada kolom <strong>Poin<\/strong> secara descending (dari terbesar ke terkecil).<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> SortMultipleColumns()\n    Range(\" <span style=\"color: #ff0000;\">A1:B11<\/span> \").Sort Key1:=Range(\" <span style=\"color: #ff0000;\">A1<\/span> \"), Order1:=xlAscending, _\n                         Key2:=Range(\" <span style=\"color: #ff0000;\">B1<\/span> \"), Order2:=xlDescending, _\n                         Header:=xlYes\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34027 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbasort2.jpg\" alt=\"\" width=\"466\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Baris sekarang diurutkan berdasarkan nama tim dalam urutan menaik dan berdasarkan poin dalam urutan menurun.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #1<\/strong> : Dalam contoh ini, kami mengurutkan berdasarkan dua kolom. Namun, Anda dapat menentukan kunci sebanyak yang Anda inginkan untuk mengurutkan lebih banyak kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #2<\/strong> : Anda dapat menemukan dokumentasi lengkap metode <strong>pengurutan<\/strong> VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.range.sort\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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 VBA:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/rata-rata-vba-jika\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi AVERAGEIF dan AVERAGEIFS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi SUMIF dan SUMIFS<\/a><br \/> VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk mengurutkan lembar Excel berdasarkan beberapa kolom menggunakan VBA: Sub SortMultipleColumns() Range(&#8221; A1:B11 &#8220;).Sort Key1:=Range(&#8221; A1 &#8220;), Order1:=xlAscending, _ Key2:=Range(&#8221; B1 &#8220;), Order2:=xlDescending, _ Header:=xlYes End Sub Contoh khusus ini mengurutkan sel dalam rentang A1:B11 terlebih dahulu berdasarkan nilai di kolom A dalam urutan menaik, kemudian berdasarkan nilai di [&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>VBA: Cara mengurutkan lembar berdasarkan beberapa kolom - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan lembar Excel berdasarkan beberapa kolom menggunakan VBA, 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\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara mengurutkan lembar berdasarkan beberapa kolom - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan lembar Excel berdasarkan beberapa kolom menggunakan VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T23:04:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbasort1.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\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/\",\"name\":\"VBA: Cara mengurutkan lembar berdasarkan beberapa kolom - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T23:04:42+00:00\",\"dateModified\":\"2023-07-11T23:04:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan lembar Excel berdasarkan beberapa kolom menggunakan VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara mengurutkan lembar berdasarkan beberapa kolom\"}]},{\"@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":"VBA: Cara mengurutkan lembar berdasarkan beberapa kolom - Statologi","description":"Tutorial ini menjelaskan cara mengurutkan lembar Excel berdasarkan beberapa kolom menggunakan VBA, 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\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara mengurutkan lembar berdasarkan beberapa kolom - Statologi","og_description":"Tutorial ini menjelaskan cara mengurutkan lembar Excel berdasarkan beberapa kolom menggunakan VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-11T23:04:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbasort1.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\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/","url":"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/","name":"VBA: Cara mengurutkan lembar berdasarkan beberapa kolom - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T23:04:42+00:00","dateModified":"2023-07-11T23:04:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan lembar Excel berdasarkan beberapa kolom menggunakan VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-mengurutkan-lembar-berdasarkan-beberapa-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara mengurutkan lembar berdasarkan beberapa kolom"}]},{"@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\/4329"}],"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=4329"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4329\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}