{"id":4794,"date":"2023-07-07T21:12:03","date_gmt":"2023-07-07T21:12:03","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/"},"modified":"2023-07-07T21:12:03","modified_gmt":"2023-07-07T21:12:03","slug":"excel-menyorot-nilai-yang-muncul-3-kali","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/","title":{"rendered":"Excel: cara menyorot nilai yang muncul 3 kali"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menyorot nilai dalam kumpulan data di Excel yang muncul 3 kali.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dengan menggunakan fitur <strong>Aturan Baru<\/strong> di Opsi <strong>Pemformatan Bersyarat<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Sorot Nilai yang Muncul 3 Kali di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37417 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hv2.png\" alt=\"\" width=\"502\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menyorot semua nama tim yang muncul 3 kali.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita dapat menyorot rentang sel <strong>A2:A14<\/strong> , lalu klik ikon <strong>pemformatan bersyarat<\/strong> pada tab <strong>Beranda<\/strong> di pita atas, lalu klik <strong>Aturan Baru<\/strong> dari menu drop-down:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35090 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etat-neuf1.png\" alt=\"\" width=\"514\" height=\"372\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Gunakan rumus untuk menentukan sel mana yang akan diformat<\/strong> , lalu masukkan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF($A$2:$A14,$A2)=3<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kemudian klik tombol <strong>Format<\/strong> dan pilih warna yang akan digunakan untuk pemformatan bersyarat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan memilih hijau muda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37418\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hv1.png\" alt=\"Excel menyoroti nilai yang muncul 3 kali\" width=\"564\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik <strong>OK<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setiap nama tim yang muncul 3 kali kini akan disorot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37419 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hv3.png\" alt=\"\" width=\"504\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam kumpulan data khusus ini, nama tim &#8220;Mavs&#8221; dan &#8220;Nets&#8221; keduanya muncul 3 kali, sehingga masing-masing nama tim ini disorot sementara nama tim lainnya tetap utuh.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda ingin menyorot seluruh baris untuk setiap tim yang muncul 3 kali, Anda cukup menyorot rentang sel <strong>A2:C14<\/strong> sebelum mengklik ikon <strong>pemformatan bersyarat<\/strong> dan memasukkan aturan baru.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini akan memungkinkan Anda menerapkan pemformatan bersyarat ke seluruh baris untuk setiap tim yang muncul 3 kali:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37420 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hv4.png\" alt=\"\" width=\"525\" height=\"441\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam contoh ini, kami memilih untuk menggunakan isian hijau muda untuk pemformatan sel bersyarat, namun Anda dapat memilih warna isian apa pun yang Anda inginkan.<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menyorot-nilai-maksimal-di-setiap-baris\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menyorot nilai maksimum di setiap baris<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menyorot sel jika nilainya ada dalam daftar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/baris-highlight-excel-berdasarkan-nilai-sel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menyorot seluruh baris berdasarkan nilai sel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menyorot nilai dalam kumpulan data di Excel yang muncul 3 kali. Untungnya, hal ini mudah dilakukan dengan menggunakan fitur Aturan Baru di Opsi Pemformatan Bersyarat . Contoh berikut menunjukkan cara melakukan hal ini. Contoh: Sorot Nilai yang Muncul 3 Kali di Excel Katakanlah kita memiliki kumpulan data berikut di Excel yang [&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 menyorot nilai yang muncul 3 kali - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyorot nilai yang muncul tiga kali 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\/excel-menyorot-nilai-yang-muncul-3-kali\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menyorot nilai yang muncul 3 kali - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyorot nilai yang muncul tiga kali di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T21:12:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hv2.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\/excel-menyorot-nilai-yang-muncul-3-kali\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/\",\"name\":\"Excel: Cara menyorot nilai yang muncul 3 kali - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T21:12:03+00:00\",\"dateModified\":\"2023-07-07T21:12:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyorot nilai yang muncul tiga kali di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menyorot nilai yang muncul 3 kali\"}]},{\"@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 menyorot nilai yang muncul 3 kali - Statorials","description":"Tutorial ini menjelaskan cara menyorot nilai yang muncul tiga kali 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\/excel-menyorot-nilai-yang-muncul-3-kali\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menyorot nilai yang muncul 3 kali - Statorials","og_description":"Tutorial ini menjelaskan cara menyorot nilai yang muncul tiga kali di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/","og_site_name":"Statorials","article_published_time":"2023-07-07T21:12:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hv2.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\/excel-menyorot-nilai-yang-muncul-3-kali\/","url":"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/","name":"Excel: Cara menyorot nilai yang muncul 3 kali - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T21:12:03+00:00","dateModified":"2023-07-07T21:12:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyorot nilai yang muncul tiga kali di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menyorot-nilai-yang-muncul-3-kali\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menyorot nilai yang muncul 3 kali"}]},{"@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\/4794"}],"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=4794"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4794\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}