{"id":2222,"date":"2023-07-23T04:57:02","date_gmt":"2023-07-23T04:57:02","guid":{"rendered":"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/"},"modified":"2023-07-23T04:57:02","modified_gmt":"2023-07-23T04:57:02","slug":"kemunculan-nomor-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/","title":{"rendered":"Cara menghitung jumlah kemunculan di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>=UNIQUE()<\/strong> dan <strong>=COUNTIF()<\/strong> untuk menghitung jumlah kemunculan nilai yang berbeda di kolom Google Sheets.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nama beberapa tim bola basket profesional di kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20359 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/se-produire1.png\" alt=\"\" width=\"540\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan nilai unik di kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari gunakan fungsi <strong>=UNIQUE()<\/strong> untuk membuat daftar setiap nama tim unik di kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20360 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/se-produire2.png\" alt=\"\" width=\"540\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi ini membuat array nilai unik secara default.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung kemunculan setiap nilai unik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari kita gunakan fungsi <strong>=COUNTIF()<\/strong> untuk menghitung jumlah kemunculan setiap nama tim unik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20361 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/se-produire3.png\" alt=\"\" width=\"547\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita hanya menyalin dan menempelkan rumus dari sel E2 ke setiap sel yang tersisa di kolom E.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nama tim \u201cHornets\u201d muncul <strong>1<\/strong> kali di kolom A.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nama tim &#8220;Hawks&#8221; muncul <strong>3<\/strong> kali di kolom A.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nama tim \u201cSpurs\u201d muncul <strong>5<\/strong> kali di kolom A.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/outlier-di-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan outlier di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-google-sheet-berdasarkan-kategori\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan nilai berdasarkan kategori di Google Sheets<\/a><br \/> Cara Menjalankan Fungsi Median IF di Google Sheets<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi =UNIQUE() dan =COUNTIF() untuk menghitung jumlah kemunculan nilai yang berbeda di kolom Google Sheets. Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan nama beberapa tim bola basket profesional di kolom A: Langkah 2: Temukan nilai unik di kolom Selanjutnya, mari [&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 jumlah kemunculan di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah kemunculan nilai tertentu dalam suatu kolom di Google Sheets.\" \/>\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\/kemunculan-nomor-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung jumlah kemunculan di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah kemunculan nilai tertentu dalam suatu kolom di Google Sheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T04:57:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/se-produire1.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\/kemunculan-nomor-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/\",\"name\":\"Cara menghitung jumlah kemunculan di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T04:57:02+00:00\",\"dateModified\":\"2023-07-23T04:57:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah kemunculan nilai tertentu dalam suatu kolom di Google Sheets.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung jumlah kemunculan di google sheets\"}]},{\"@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 jumlah kemunculan di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung jumlah kemunculan nilai tertentu dalam suatu kolom di Google Sheets.","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\/kemunculan-nomor-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung jumlah kemunculan di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung jumlah kemunculan nilai tertentu dalam suatu kolom di Google Sheets.","og_url":"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-23T04:57:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/se-produire1.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\/kemunculan-nomor-google-sheet\/","url":"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/","name":"Cara menghitung jumlah kemunculan di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T04:57:02+00:00","dateModified":"2023-07-23T04:57:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah kemunculan nilai tertentu dalam suatu kolom di Google Sheets.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung jumlah kemunculan di google sheets"}]},{"@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\/2222"}],"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=2222"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2222\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}