{"id":4631,"date":"2023-07-09T11:28:09","date_gmt":"2023-07-09T11:28:09","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/"},"modified":"2023-07-09T11:28:09","modified_gmt":"2023-07-09T11:28:09","slug":"excel-menghitung-nama-unik","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/","title":{"rendered":"Cara menghitung nama unik di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menghitung jumlah nama unik dalam suatu rentang di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--(FREQUENCY(MATCH( <span style=\"color: #3366ff;\">A2:A12<\/span> , <span style=\"color: #3366ff;\">A2:A12<\/span> ,0),ROW( <span style=\"color: #3366ff;\">A2:A12<\/span> )-ROW( <span style=\"color: #ff0000;\">A2<\/span> )+1)&gt;0))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung jumlah nama unik dalam rentang <strong>A2:A12<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mendapatkan daftar setiap nama unik, Anda dapat menggunakan fungsi <strong>UNIK<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SINGLE( <span style=\"color: #3366ff;\">A2:A12<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan mengembalikan daftar nama unik dalam rentang <strong>A2:A12<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menghitung nama unik di excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang berisi informasi tentang penjualan yang dilakukan oleh berbagai karyawan suatu perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36141 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnames1.png\" alt=\"\" width=\"433\" height=\"383\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung jumlah kata benda unik pada kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>E2<\/strong> untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--(FREQUENCY(MATCH( <span style=\"color: #3366ff;\">A2:A12<\/span> , <span style=\"color: #3366ff;\">A2:A12<\/span> ,0),ROW( <span style=\"color: #3366ff;\">A2:A12<\/span> )-ROW( <span style=\"color: #ff0000;\">A2<\/span> )+1)&gt;0))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36142 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnames2.png\" alt=\"\" width=\"558\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya menunjukkan ada <strong>6<\/strong> nama unik di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk benar-benar menampilkan daftar nama unik ini, kita bisa mengetikkan rumus berikut di sel <strong>E2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SINGLE( <span style=\"color: #3366ff;\">A2:A12<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36143 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnames3.png\" alt=\"\" width=\"460\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan enam nama unik di kolom A:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">andi<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bob<\/span><\/li>\n<li> <span style=\"color: #000000;\">anak<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kerekan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Eric<\/span><\/li>\n<li> <span style=\"color: #000000;\">Franc<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Masing-masing nama ini muncul setidaknya satu kali di kolom A dan beberapa nama muncul lebih dari satu kali.<\/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-countif-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung jika sel berisi teks<\/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>Anda bisa menggunakan rumus berikut untuk menghitung jumlah nama unik dalam suatu rentang di Excel: =SUMPRODUCT(&#8211;(FREQUENCY(MATCH( A2:A12 , A2:A12 ,0),ROW( A2:A12 )-ROW( A2 )+1)&gt;0)) Rumus khusus ini menghitung jumlah nama unik dalam rentang A2:A12 . Untuk mendapatkan daftar setiap nama unik, Anda dapat menggunakan fungsi UNIK : =SINGLE( A2:A12 ) Ini akan mengembalikan daftar nama [&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 Menghitung Nama Unik di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah nama unik di Excel, beserta 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\/excel-menghitung-nama-unik\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Nama Unik di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah nama unik di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T11:28:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnames1.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\/excel-menghitung-nama-unik\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/\",\"name\":\"Cara Menghitung Nama Unik di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T11:28:09+00:00\",\"dateModified\":\"2023-07-09T11:28:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah nama unik di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung nama unik di excel (dengan contoh)\"}]},{\"@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 Menghitung Nama Unik di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung jumlah nama unik di Excel, beserta 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\/excel-menghitung-nama-unik\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Nama Unik di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung jumlah nama unik di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/","og_site_name":"Statorials","article_published_time":"2023-07-09T11:28:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnames1.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\/excel-menghitung-nama-unik\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/","name":"Cara Menghitung Nama Unik di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T11:28:09+00:00","dateModified":"2023-07-09T11:28:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah nama unik di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-nama-unik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung nama unik di excel (dengan contoh)"}]},{"@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\/4631"}],"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=4631"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4631\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}