{"id":4694,"date":"2023-07-08T21:25:42","date_gmt":"2023-07-08T21:25:42","guid":{"rendered":"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/"},"modified":"2023-07-08T21:25:42","modified_gmt":"2023-07-08T21:25:42","slug":"grup-excel-berdasarkan-nama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/","title":{"rendered":"Cara mengelompokkan berdasarkan nama di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin mengelompokkan nilai kumpulan data di Excel berdasarkan nama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita mempunyai kumpulan data berikut dan ingin menjumlahkan total penjualan berdasarkan nama karyawan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36660 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gnom.png\" alt=\"\" width=\"452\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai data ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36660 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gnom.png\" alt=\"\" width=\"452\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan Nama Unik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menggunakan fungsi <strong>=UNIQUE()<\/strong> untuk menghasilkan daftar nama unik dalam rentang tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, kita akan mengetikkan rumus berikut di sel <strong>D2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SINGLE( <span style=\"color: #3366ff;\">A2:A12<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan menghasilkan daftar nama unik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36661 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nomg1.png\" alt=\"\" width=\"471\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung jumlah berdasarkan nama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan fungsi <strong>SUMIF(range, kriteria, sum_range)<\/strong> untuk mencari jumlah penjualan setiap karyawan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus berikut di sel <strong>E2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMIF( <span style=\"color: #3366ff;\">$A$2:$A$12<\/span> , <span style=\"color: #ff0000;\">D2<\/span> , <span style=\"color: #800080;\">$B$2:$B$12<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36662\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nomg2.png\" alt=\"Grup Excel berdasarkan nama\" width=\"522\" height=\"401\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah penjualan yang dilakukan Andy adalah <strong>23<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah penjualan yang dilakukan Bob adalah <strong>12<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah penjualan yang dilakukan Chad adalah <strong>28<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah penjualan yang dilakukan Doug adalah <strong>17<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kami menggunakan fungsi <strong>SUMIF<\/strong> untuk menghitung jumlah berdasarkan nama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda bisa menggunakan <strong>COUNTIF<\/strong> , <strong>AVERAGEIF<\/strong> , atau fungsi lain untuk menghitung hitungan, rata-rata, atau ukuran keseluruhan lainnya yang dikelompokkan berdasarkan nama.<\/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> <a href=\"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-warna\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan warna di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-excel-per-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan berdasarkan bulan di excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/dihitung-berdasarkan-grup-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung berdasarkan kelompok di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin mengelompokkan nilai kumpulan data di Excel berdasarkan nama. Misalnya, kita mempunyai kumpulan data berikut dan ingin menjumlahkan total penjualan berdasarkan nama karyawan: Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan nilai data ke dalam Excel: Langkah 2: Temukan Nama Unik Selanjutnya, kita perlu [&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 Mengelompokkan Berdasarkan Nama di Excel (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan baris di Excel berdasarkan nama, 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\/grup-excel-berdasarkan-nama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengelompokkan Berdasarkan Nama di Excel (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan baris di Excel berdasarkan nama, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T21:25:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gnom.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\/grup-excel-berdasarkan-nama\/\",\"url\":\"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/\",\"name\":\"Cara Mengelompokkan Berdasarkan Nama di Excel (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T21:25:42+00:00\",\"dateModified\":\"2023-07-08T21:25:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan baris di Excel berdasarkan nama, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengelompokkan berdasarkan nama 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 Mengelompokkan Berdasarkan Nama di Excel (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara mengelompokkan baris di Excel berdasarkan nama, 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\/grup-excel-berdasarkan-nama\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengelompokkan Berdasarkan Nama di Excel (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara mengelompokkan baris di Excel berdasarkan nama, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/","og_site_name":"Statorials","article_published_time":"2023-07-08T21:25:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gnom.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\/grup-excel-berdasarkan-nama\/","url":"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/","name":"Cara Mengelompokkan Berdasarkan Nama di Excel (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T21:25:42+00:00","dateModified":"2023-07-08T21:25:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan baris di Excel berdasarkan nama, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grup-excel-berdasarkan-nama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengelompokkan berdasarkan nama 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\/4694"}],"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=4694"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4694\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}