{"id":3516,"date":"2023-07-17T02:01:45","date_gmt":"2023-07-17T02:01:45","guid":{"rendered":"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/"},"modified":"2023-07-17T02:01:45","modified_gmt":"2023-07-17T02:01:45","slug":"nilai-maksimal-google-sheet-per-grup","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/","title":{"rendered":"Google sheets: cara menemukan nilai maksimum berdasarkan grup"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin mencari nilai maksimum kumpulan data di Google Spreadsheet 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-29239 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-max1.jpg\" alt=\"\" width=\"507\" height=\"467\" 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 Google Sheets:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29239 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-max1.jpg\" alt=\"\" width=\"507\" height=\"467\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan grup unik<\/strong><\/span><\/h2>\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: #ff6600;\">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-29240 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-max2.jpg\" alt=\"\" width=\"512\" height=\"507\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Temukan nilai maksimum per grup<\/strong><\/span><\/h2>\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>= <span class=\" default-formula-text-color\" dir=\"auto\">ArrayFormula<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> MAX(IF( <span style=\"color: #ff6600;\">A:A<\/span> = <span style=\"color: #800080;\">D2<\/span> , <span style=\"color: #008080;\">B:B<\/span> )))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>E2<\/strong> , lalu menyeretnya ke sel lainnya di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-29241\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-max3.jpg\" alt=\"nilai maksimum per grup di Google Spreadsheet\" width=\"555\" height=\"491\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/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<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 Google Spreadsheet:<\/span><\/p>\n<p> Cara mengelompokkan data berdasarkan minggu di Google Sheets<br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-grup-google-per-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan data berdasarkan bulan di Google Sheets<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan Group By di kueri Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin mencari nilai maksimum kumpulan data di Google Spreadsheet 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 Google Sheets: Langkah 2: Temukan [&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>Google Spreadsheet: Cara menemukan nilai maksimum berdasarkan grup \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menemukan nilai maksimum per grup di Google Sheets, 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-google-sheet-per-grup\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara menemukan nilai maksimum berdasarkan grup \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menemukan nilai maksimum per grup di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T02:01:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-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-google-sheet-per-grup\/\",\"url\":\"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/\",\"name\":\"Google Spreadsheet: Cara menemukan nilai maksimum berdasarkan grup \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T02:01:45+00:00\",\"dateModified\":\"2023-07-17T02:01:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menemukan nilai maksimum per grup di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara menemukan nilai maksimum berdasarkan grup\"}]},{\"@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":"Google Spreadsheet: Cara menemukan nilai maksimum berdasarkan grup \u2013 Statorial","description":"Tutorial ini menjelaskan cara menemukan nilai maksimum per grup di Google Sheets, 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-google-sheet-per-grup\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menemukan nilai maksimum berdasarkan grup \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menemukan nilai maksimum per grup di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/","og_site_name":"Statorials","article_published_time":"2023-07-17T02:01:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupe-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-google-sheet-per-grup\/","url":"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/","name":"Google Spreadsheet: Cara menemukan nilai maksimum berdasarkan grup \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T02:01:45+00:00","dateModified":"2023-07-17T02:01:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menemukan nilai maksimum per grup di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara menemukan nilai maksimum berdasarkan grup"}]},{"@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\/3516"}],"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=3516"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3516\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}