{"id":4367,"date":"2023-07-11T16:08:58","date_gmt":"2023-07-11T16:08:58","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/"},"modified":"2023-07-11T16:08:58","modified_gmt":"2023-07-11T16:08:58","slug":"vba-mengurutkan-berdasarkan-abjad","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/","title":{"rendered":"Vba: cara mengurutkan nilai berdasarkan abjad"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut di VBA untuk mengurutkan nilai dalam rentang berdasarkan abjad:<\/span><\/p>\n

 Sub<\/span> SortAlphabetical()\nRange(\" A1:B11<\/span> \").Sort Key1:=Range(\" A1<\/span> \"), Order1:=xlAscending, Header:=xlYes\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Contoh khusus ini mengurutkan baris dalam rentang A1:B11<\/strong> berdasarkan nilai di kolom A menurut abjad (A hingga Z).<\/span><\/p>\n
 Jika Anda ingin mengurutkan nilai dalam urutan abjad terbalik (Z ke A), Anda dapat menentukan Order1:=xlDescending<\/strong> sebagai gantinya.<\/span><\/p>\n
 Perhatikan bahwa Header:=xlYes<\/strong> menetapkan bahwa baris pertama harus diperlakukan sebagai baris header.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Mengurutkan Nilai Berdasarkan Abjad Menggunakan VBA<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin mengurutkan baris berdasarkan nama tim berdasarkan abjad.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 Sub<\/span> SortAlphabetical()\nRange(\" A1:B11<\/span> \").Sort Key1:=Range(\" A1<\/span> \"), Order1:=xlAscending, Header:=xlYes\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Baris sekarang diurutkan berdasarkan nama tim menurut abjad (A sampai Z).<\/span><\/p>\n
 Untuk mengurutkan baris dalam urutan abjad terbalik (Z ke A), kita dapat menentukan Order1:=xlDescending<\/strong> :<\/span><\/p>\n
 Sub<\/span> SortAlphabetical()\nRange(\" A1:B11<\/span> \").Sort Key1:=Range(\" A1<\/span> \"), Order1:=xlDescending, Header:=xlYes\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Baris sekarang diurutkan berdasarkan nama tim dalam urutan abjad terbalik (Z ke A).<\/span><\/p>\n
 Catatan #1<\/strong> : Dalam contoh ini, kami mengurutkan dalam satu kolom. Namun, Anda dapat menentukan lebih banyak kunci<\/strong> untuk mengurutkan pada beberapa kolom.<\/span><\/p>\n
 Catatan #2<\/strong> : Anda dapat menemukan dokumentasi lengkap metode pengurutan<\/strong> VBA di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara mengurutkan lembar berdasarkan beberapa kolom<\/a>
 VBA: Cara menghitung jumlah baris dalam jangkauan<\/a>
 VBA: cara memfilter kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut di VBA untuk mengurutkan nilai dalam rentang berdasarkan abjad: Sub SortAlphabetical() Range(” A1:B11 “).Sort Key1:=Range(” A1 “), Order1:=xlAscending, Header:=xlYes End Sub Contoh khusus ini mengurutkan baris dalam rentang A1:B11 berdasarkan nilai di kolom A menurut abjad (A hingga Z). Jika Anda ingin mengurutkan nilai dalam urutan abjad terbalik (Z […]<\/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":"\nVBA: Cara mengurutkan nilai berdasarkan abjad \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan nilai berdasarkan abjad di Excel 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-berdasarkan-abjad\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara mengurutkan nilai berdasarkan abjad \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan nilai berdasarkan abjad di Excel menggunakan VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T16:08:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sa1.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-berdasarkan-abjad\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/\",\"name\":\"VBA: Cara mengurutkan nilai berdasarkan abjad \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T16:08:58+00:00\",\"dateModified\":\"2023-07-11T16:08:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan nilai berdasarkan abjad di Excel menggunakan VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara mengurutkan nilai berdasarkan abjad\"}]},{\"@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 nilai berdasarkan abjad \u2013 Statologi","description":"Tutorial ini menjelaskan cara mengurutkan nilai berdasarkan abjad di Excel 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-berdasarkan-abjad\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara mengurutkan nilai berdasarkan abjad \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara mengurutkan nilai berdasarkan abjad di Excel menggunakan VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/","og_site_name":"Statorials","article_published_time":"2023-07-11T16:08:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sa1.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-berdasarkan-abjad\/","url":"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/","name":"VBA: Cara mengurutkan nilai berdasarkan abjad \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T16:08:58+00:00","dateModified":"2023-07-11T16:08:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan nilai berdasarkan abjad di Excel menggunakan VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-mengurutkan-berdasarkan-abjad\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara mengurutkan nilai berdasarkan abjad"}]},{"@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\/4367"}],"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=4367"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4367\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}