{"id":2710,"date":"2023-07-21T01:57:06","date_gmt":"2023-07-21T01:57:06","guid":{"rendered":"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/"},"modified":"2023-07-21T01:57:06","modified_gmt":"2023-07-21T01:57:06","slug":"nilai-maksimal-excel-per-grup","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/","title":{"rendered":"Excel: cara mencari nilai maksimum berdasarkan kelompok"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin mencari nilai maksimum kumpulan data di Excel berdasarkan kategori atau grup.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita memiliki kumpulan data berikut dan ingin mencari nilai &#8220;poin&#8221; maksimum untuk setiap tim:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23879 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/max1.jpg\" alt=\"\" width=\"430\" height=\"413\" srcset=\"\" sizes=\"\"><\/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;\">Pertama, masukkan nilai data ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23879 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/max1.jpg\" alt=\"\" width=\"430\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan grup unik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menggunakan fungsi <strong>=UNIQUE()<\/strong> untuk menghasilkan daftar nama tim yang unik.<\/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:A16<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan menghasilkan daftar tim unik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23880 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/max2.jpg\" alt=\"\" width=\"513\" height=\"489\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Temukan nilai maksimum per grup<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menggunakan rumus berikut untuk mencari poin maksimal yang dicetak oleh masing-masing tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MAX(IF( <span style=\"color: #3366ff;\">A:A<\/span> = <span style=\"color: #ff0000;\">D2<\/span> , <span style=\"color: #800080;\">B:B<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>E2<\/strong> , lalu salin dan tempel ke sel lainnya di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23881 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/max3.jpg\" alt=\"\" width=\"469\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Poin maksimum yang dicetak oleh pemain di Mavs adalah <strong>26<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Poin maksimal yang dicetak pemain di Warriors adalah <strong>19<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Poin maksimal yang dicetak pemain Lakers adalah <strong>33<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Poin maksimal yang dicetak pemain di Heat adalah <strong>19<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Poin maksimal yang dicetak pemain Celtics adalah <strong>29<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Untuk menghitung poin minimum yang dicetak oleh masing-masing tim, cukup ganti <strong>MAX<\/strong> di rumus dengan <strong>MIN<\/strong> .<\/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 Excel:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/dihitung-berdasarkan-grup-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung berdasarkan kelompok di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-berdasarkan-grup-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah berdasarkan kelompok di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rangkuman Lima Angka di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin mencari nilai maksimum kumpulan data di Excel berdasarkan kategori atau grup. Misalnya, kita memiliki kumpulan data berikut dan ingin mencari nilai &#8220;poin&#8221; maksimum untuk setiap tim: Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan nilai data ke dalam Excel: Langkah 2: Temukan 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>Excel: Cara mencari nilai maksimum berdasarkan grup \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari nilai maksimum 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\/nilai-maksimal-excel-per-grup\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mencari nilai maksimum berdasarkan grup \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari nilai maksimum berdasarkan grup di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T01:57:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/max1.jpg\" \/>\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\/nilai-maksimal-excel-per-grup\/\",\"url\":\"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/\",\"name\":\"Excel: Cara mencari nilai maksimum berdasarkan grup \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T01:57:06+00:00\",\"dateModified\":\"2023-07-21T01:57:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari nilai maksimum berdasarkan grup di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mencari nilai maksimum berdasarkan kelompok\"}]},{\"@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":"Excel: Cara mencari nilai maksimum berdasarkan grup \u2013 Statorials","description":"Tutorial ini menjelaskan cara mencari nilai maksimum 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\/nilai-maksimal-excel-per-grup\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mencari nilai maksimum berdasarkan grup \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mencari nilai maksimum berdasarkan grup di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/","og_site_name":"Statorials","article_published_time":"2023-07-21T01:57:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/max1.jpg"}],"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\/nilai-maksimal-excel-per-grup\/","url":"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/","name":"Excel: Cara mencari nilai maksimum berdasarkan grup \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T01:57:06+00:00","dateModified":"2023-07-21T01:57:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari nilai maksimum berdasarkan grup di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nilai-maksimal-excel-per-grup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mencari nilai maksimum berdasarkan kelompok"}]},{"@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\/2710"}],"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=2710"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2710\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}