{"id":4622,"date":"2023-07-09T13:19:56","date_gmt":"2023-07-09T13:19:56","guid":{"rendered":"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/"},"modified":"2023-07-09T13:19:56","modified_gmt":"2023-07-09T13:19:56","slug":"nomor-urut-excel-berdasarkan-kelompok","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/","title":{"rendered":"Cara menghasilkan nomor urutan berdasarkan grup di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menghasilkan nomor urut berdasarkan grup di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #3366ff;\">$A$2:A2<\/span> , <span style=\"color: #3366ff;\">A2<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mengasumsikan bahwa nama grup unik pertama ada di sel <strong>A2<\/strong> dan semua grup lainnya juga ada di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menghasilkan Nomor Urutan berdasarkan Grup di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36072 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-seq1.png\" alt=\"\" width=\"446\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menambahkan kolom baru yang berisi nomor urut per tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Baris pertama dengan nama tim &#8220;Mavs&#8221; harus memiliki nilai <strong>1<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris kedua dengan nama tim &#8220;Mavs&#8221; harus memiliki nilai <strong>2<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris ketiga dengan nama tim &#8220;Mavs&#8221; harus bernilai <strong>3<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nomor urut akan otomatis dimulai lagi ketika nama tim baru ditemukan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk mencapai ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #3366ff;\">$A$2:A2<\/span> , <span style=\"color: #3366ff;\">A2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36073\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-seq2.png\" alt=\"Nomor urut Excel berdasarkan grup\" width=\"519\" height=\"486\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C sekarang berisi nomor urut per tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perlu dicatat bahwa rumus ini juga berfungsi meskipun nama tim tidak berurutan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita memiliki kumpulan data berikut yang nama tim diacaknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36075 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-seq4.png\" alt=\"\" width=\"446\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita masih bisa menggunakan rumus berikut di sel <strong>C2<\/strong> untuk menghasilkan nomor urut berdasarkan nama tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #3366ff;\">$A$2:A2<\/span> , <span style=\"color: #3366ff;\">A2<\/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-36074 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-seq3.png\" alt=\"\" width=\"489\" height=\"468\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nomor urutnya selalu benar.<\/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\/isi-otomatis-excel-dari-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengisi otomatis nilai dari lembar lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: cara mengisi tanggal secara otomatis<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghasilkan-angka-acak-antar-rentang\/\" target=\"_blank\" rel=\"noopener\">Excel: menghasilkan nomor acak antar rentang<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk menghasilkan nomor urut berdasarkan grup di Excel: =COUNTIF( $A$2:A2 , A2 ) Rumus khusus ini mengasumsikan bahwa nama grup unik pertama ada di sel A2 dan semua grup lainnya juga ada di kolom A. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Menghasilkan Nomor Urutan berdasarkan Grup [&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 Nomor Urutan Berdasarkan Grup di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghasilkan nomor urut berdasarkan grup 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\/nomor-urut-excel-berdasarkan-kelompok\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghasilkan Nomor Urutan Berdasarkan Grup di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghasilkan nomor urut berdasarkan grup di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T13:19:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-seq1.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\/nomor-urut-excel-berdasarkan-kelompok\/\",\"url\":\"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/\",\"name\":\"Cara Menghasilkan Nomor Urutan Berdasarkan Grup di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T13:19:56+00:00\",\"dateModified\":\"2023-07-09T13:19:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghasilkan nomor urut berdasarkan grup di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghasilkan nomor urutan berdasarkan grup 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 Nomor Urutan Berdasarkan Grup di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghasilkan nomor urut berdasarkan grup 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\/nomor-urut-excel-berdasarkan-kelompok\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghasilkan Nomor Urutan Berdasarkan Grup di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghasilkan nomor urut berdasarkan grup di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/","og_site_name":"Statorials","article_published_time":"2023-07-09T13:19:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-seq1.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\/nomor-urut-excel-berdasarkan-kelompok\/","url":"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/","name":"Cara Menghasilkan Nomor Urutan Berdasarkan Grup di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T13:19:56+00:00","dateModified":"2023-07-09T13:19:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghasilkan nomor urut berdasarkan grup di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nomor-urut-excel-berdasarkan-kelompok\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghasilkan nomor urutan berdasarkan grup 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\/4622"}],"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=4622"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4622\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}