{"id":4872,"date":"2023-07-07T00:21:06","date_gmt":"2023-07-07T00:21:06","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/"},"modified":"2023-07-07T00:21:06","modified_gmt":"2023-07-07T00:21:06","slug":"vba-mendapatkan-nilai-unik-dari-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/","title":{"rendered":"Vba: cara mendapatkan nilai unik dari sebuah kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>AdvancedFilter<\/strong> di VBA untuk dengan cepat mendapatkan daftar nilai unik dari kolom di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara umum untuk melakukannya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> GetUniqueValues()\n\nRange(\" <span style=\"color: #ff0000;\">A1:A11<\/span> \").AdvancedFilter_\n                Action:=xlFilterCopy, CopyToRange:=Range(\" <span style=\"color: #ff0000;\">E1<\/span> \"), Unique:= <span style=\"color: #0000ff;\">True<\/span>\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini mengekstrak daftar nilai unik dari rentang <strong>A1:A11<\/strong> dan menampilkannya dari sel <strong>E1<\/strong> .<\/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: Dapatkan nilai unik dari 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-38047 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/guni1.png\" alt=\"\" width=\"505\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mengekstrak daftar nilai unik dari kolom <strong>Tim<\/strong> .<\/span><\/p>\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> GetUniqueValues()\n\nRange(\" <span style=\"color: #ff0000;\">A1:A11<\/span> \").AdvancedFilter_\n                Action:=xlFilterCopy, CopyToRange:=Range(\" <span style=\"color: #ff0000;\">E1<\/span> \"), Unique:= <span style=\"color: #0000ff;\">True<\/span>\n\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-38048 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/guni2.png\" alt=\"\" width=\"512\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom E sekarang menampilkan daftar nilai unik dari kolom <strong>Tim<\/strong> di kumpulan data asli.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa metode <strong>AdvancedFilter<\/strong> tidak peka huruf besar-kecil.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, jika kita memiliki nama tim &#8220;MAVS&#8221; dan &#8220;Mavs&#8221; di kolom yang sama, makro khusus ini hanya akan mengembalikan nilai pertama dari dua nilai yang muncul di kolom <strong>Tim<\/strong> karena keduanya memiliki karakter yang sama persis.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap metode <strong>AdvancedFilter<\/strong> di VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.range.advancedfilter\" 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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/vba-menghitung-sel-dengan-teks-tertentu\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung sel dengan teks tertentu<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-vba-unik\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung nilai unik dalam rentang<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi AdvancedFilter di VBA untuk dengan cepat mendapatkan daftar nilai unik dari kolom di Excel. Berikut cara umum untuk melakukannya: Sub GetUniqueValues() Range(&#8221; A1:A11 &#8220;).AdvancedFilter_ Action:=xlFilterCopy, CopyToRange:=Range(&#8221; E1 &#8220;), Unique:= True End Sub Contoh khusus ini mengekstrak daftar nilai unik dari rentang A1:A11 dan menampilkannya dari sel E1 . Contoh berikut menunjukkan [&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 mendapatkan nilai unik dari kolom - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mendapatkan nilai unik dari kolom di Excel menggunakan VBA, dengan beberapa 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-mendapatkan-nilai-unik-dari-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara mendapatkan nilai unik dari kolom - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mendapatkan nilai unik dari kolom di Excel menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T00:21:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/guni1.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\/vba-mendapatkan-nilai-unik-dari-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/\",\"name\":\"VBA: Cara mendapatkan nilai unik dari kolom - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T00:21:06+00:00\",\"dateModified\":\"2023-07-07T00:21:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mendapatkan nilai unik dari kolom di Excel menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara mendapatkan nilai unik dari sebuah 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 mendapatkan nilai unik dari kolom - Statologi","description":"Tutorial ini menjelaskan cara mendapatkan nilai unik dari kolom di Excel menggunakan VBA, dengan beberapa 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-mendapatkan-nilai-unik-dari-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara mendapatkan nilai unik dari kolom - Statologi","og_description":"Tutorial ini menjelaskan cara mendapatkan nilai unik dari kolom di Excel menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-07T00:21:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/guni1.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\/vba-mendapatkan-nilai-unik-dari-kolom\/","url":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/","name":"VBA: Cara mendapatkan nilai unik dari kolom - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T00:21:06+00:00","dateModified":"2023-07-07T00:21:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mendapatkan nilai unik dari kolom di Excel menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-unik-dari-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara mendapatkan nilai unik dari sebuah 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\/4872"}],"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=4872"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4872\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}