{"id":4828,"date":"2023-07-07T12:11:42","date_gmt":"2023-07-07T12:11:42","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/"},"modified":"2023-07-07T12:11:42","modified_gmt":"2023-07-07T12:11:42","slug":"excel-menghitung-kata-yang-berulang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/","title":{"rendered":"Cara menghitung kata berulang di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menghitung berapa kali sebuah kata diulang dalam kolom di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda memiliki daftar nama tim bola basket berikut dan ingin menghitung jumlah pengulangan nama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37693 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crep1.png\" alt=\"\" width=\"481\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan penghitungan berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1.<\/strong> Hitung berapa kali setiap nama tim unik diulang<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> Hitung jumlah total nama tim yang diulang (termasuk kemunculan pertama)<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>3.<\/strong> Hitung jumlah nama tim yang diulang (tidak termasuk kemunculan pertama)<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung berapa kali setiap kata diulang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menghitung berapa kali setiap nama tim unik diulang, pertama-tama kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk mendapatkan daftar nama tim unik:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SINGLE( <span style=\"color: #3366ff;\">A2:A11<\/span> )<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37694 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crep2.png\" alt=\"\" width=\"485\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk menghitung berapa kali setiap nama tim diulang:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #3366ff;\">$A$2:$A$11<\/span> , <span style=\"color: #ff0000;\">C2<\/span> )<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37695\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crep3.png\" alt=\"Excel menghitung kata yang berulang\" width=\"534\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom D sekarang menunjukkan berapa kali setiap nama tim unik muncul.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung jumlah total kata yang diulang (termasuk kemunculan pertama)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menghitung jumlah total pengulangan (termasuk kemunculan pertama) di kolom tim, Anda bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=ROWS( <span style=\"color: #3366ff;\">$A$2:$A$11<\/span> )-SUM(IF(COUNTIF( <span style=\"color: #3366ff;\">$A$2:$A$11<\/span> , <span style=\"color: #3366ff;\">$A$2:$A$11<\/span> ) =1,1,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-37696 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crep4.png\" alt=\"\" width=\"676\" height=\"344\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya memberitahu kita bahwa ada total <strong>8<\/strong> kata yang diulang (termasuk kemunculan pertama) di kolom tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan mengidentifikasi 8 kata yang diulang secara manual:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37698 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crepe5.png\" alt=\"\" width=\"482\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Hitung jumlah kata yang diulang (tidak termasuk kemunculan pertama)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menghitung jumlah total pengulangan (tidak termasuk kemunculan pertama) pada kolom tim, pertama-tama kita dapat mengetikkan rumus berikut pada sel <strong>B2<\/strong> untuk menentukan apakah setiap baris mewakili pengulangan atau tidak:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(COUNTIF( <span style=\"color: #3366ff;\">$A$2:$A2<\/span> , <span style=\"color: #3366ff;\">A2<\/span> )&gt;1,\"Yes\",\"No\")<\/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-37699 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crepe6.png\" alt=\"\" width=\"539\" height=\"398\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk menghitung jumlah total kata yang diulang (tidak termasuk kemunculan pertama) di kolom tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #3366ff;\">B2:B11<\/span> , \"Yes\")<\/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-37700 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crepe7.png\" alt=\"\" width=\"508\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa ada total <strong>5<\/strong> kata yang diulang (tidak termasuk kemunculan pertama) di kolom tim.<\/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>Seringkali Anda mungkin ingin menghitung berapa kali sebuah kata diulang dalam kolom di Excel. Misalnya, Anda memiliki daftar nama tim bola basket berikut dan ingin menghitung jumlah pengulangan nama: Contoh berikut menunjukkan cara melakukan penghitungan berikut: 1. Hitung berapa kali setiap nama tim unik diulang 2. Hitung jumlah total nama tim yang diulang (termasuk kemunculan [&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 Kata Berulang di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung kata berulang di Excel, 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\/excel-menghitung-kata-yang-berulang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Kata Berulang di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung kata berulang di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T12:11:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crep1.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=\"2 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-kata-yang-berulang\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/\",\"name\":\"Cara Menghitung Kata Berulang di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T12:11:42+00:00\",\"dateModified\":\"2023-07-07T12:11:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung kata berulang di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung kata berulang 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 Kata Berulang di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung kata berulang di Excel, 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\/excel-menghitung-kata-yang-berulang\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Kata Berulang di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung kata berulang di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/","og_site_name":"Statorials","article_published_time":"2023-07-07T12:11:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crep1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/","name":"Cara Menghitung Kata Berulang di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T12:11:42+00:00","dateModified":"2023-07-07T12:11:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung kata berulang di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-kata-yang-berulang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung kata berulang 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\/4828"}],"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=4828"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4828\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4828"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4828"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4828"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}