{"id":4934,"date":"2023-07-06T05:44:20","date_gmt":"2023-07-06T05:44:20","guid":{"rendered":"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/"},"modified":"2023-07-06T05:44:20","modified_gmt":"2023-07-06T05:44:20","slug":"pengidentifikasi-unik-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/","title":{"rendered":"Cara menghasilkan id unik di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat pengidentifikasi unik untuk nilai dalam kumpulan data di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menghasilkan ID Unik di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar nama tim bola basket berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38518 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/unid1.png\" alt=\"\" width=\"430\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat nilai ID unik untuk setiap tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat memilih nilai pilihan kita sebagai pengidentifikasi unik pertama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita bisa menggunakan nilai <strong>1<\/strong> untuk tim pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38519 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/unid2.png\" alt=\"\" width=\"437\" height=\"389\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, kita bisa mengetikkan rumus berikut di sel <strong>B3<\/strong> :<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(ISNA(MATCH( <span style=\"color: #3366ff;\">A3<\/span> , <span style=\"color: #ff0000;\">A2:$A$2<\/span> ,0)),MAX( <span style=\"color: #800080;\">B2:$B$2<\/span> )+1,VLOOKUP( <span style=\"color: #3366ff;\">A3<\/span> , <span style=\"color: #008000;\">A2:$B$2<\/span> ,2,FALSE))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38520 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/unid3.png\" alt=\"\" width=\"501\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kolom B sekarang berisi nilai ID unik untuk setiap tim.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Setiap tim dengan nama &#8220;Mavs&#8221; memiliki nilai ID sebesar <strong>1<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Setiap tim dengan nama &#8220;Lakers&#8221; memiliki nilai identifikasi <strong>2<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Setiap tim dengan nama &#8220;Hawks&#8221; memiliki nilai ID sebesar <strong>3<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin bisa membedakan pemain di tim yang sama, Anda bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk menghasilkan pengidentifikasi unik yang berisi tiga huruf pertama nama tim serta nilai numerik untuk menunjukkan penampilan tim. tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEFT( <span style=\"color: #3366ff;\">A2<\/span> ,3)&amp;\"-\"&amp;COUNTIF( <span style=\"color: #3366ff;\">$A$2:A2<\/span> , <span style=\"color: #3366ff;\">A2<\/span> )*1<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Anda kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38521 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/unid4.png\" alt=\"\" width=\"538\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kolom B sekarang berisi pengidentifikasi unik untuk setiap baris.<\/span><\/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 Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung nama unik<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung nilai unik berdasarkan grup<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung nilai unik berdasarkan beberapa kriteria<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat pengidentifikasi unik untuk nilai dalam kumpulan data di Excel. Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Contoh: Menghasilkan ID Unik di Excel Misalkan kita memiliki daftar nama tim bola basket berikut di Excel: Katakanlah kita ingin membuat nilai ID unik untuk setiap tim. Untuk melakukan ini, kita dapat [&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 Menghasilkan ID Unik di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghasilkan pengidentifikasi unik di Excel, 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\/pengidentifikasi-unik-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghasilkan ID Unik di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghasilkan pengidentifikasi unik di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T05:44:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/unid1.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\/pengidentifikasi-unik-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/\",\"name\":\"Cara Menghasilkan ID Unik di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T05:44:20+00:00\",\"dateModified\":\"2023-07-06T05:44:20+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghasilkan pengidentifikasi unik di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghasilkan id unik 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 Menghasilkan ID Unik di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghasilkan pengidentifikasi unik di Excel, 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\/pengidentifikasi-unik-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghasilkan ID Unik di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghasilkan pengidentifikasi unik di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-06T05:44:20+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/unid1.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\/pengidentifikasi-unik-excel\/","url":"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/","name":"Cara Menghasilkan ID Unik di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T05:44:20+00:00","dateModified":"2023-07-06T05:44:20+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghasilkan pengidentifikasi unik di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pengidentifikasi-unik-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghasilkan id unik 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\/4934"}],"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=4934"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4934\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4934"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}