{"id":4721,"date":"2023-07-08T14:59:13","date_gmt":"2023-07-08T14:59:13","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/"},"modified":"2023-07-08T14:59:13","modified_gmt":"2023-07-08T14:59:13","slug":"excel-menyorot-baris-duplikat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/","title":{"rendered":"Cara menyorot baris duplikat di excel (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Seringkali, Anda mungkin ingin menyorot baris di Excel jika setiap nilai dalam baris merupakan duplikat dari baris lainnya.<\/span><\/p>\n

Untungnya, hal ini mudah dilakukan dengan menggunakan fitur Aturan Baru<\/strong> di Opsi Pemformatan Bersyarat<\/strong> .<\/span><\/p>\n

Contoh berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n

Contoh: Sorot Baris Duplikat di Excel<\/strong><\/span><\/h2>\n

Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n

\"\"<\/p>\n

Katakanlah kita ingin menyorot baris duplikat, yaitu baris dengan nilai yang persis sama di setiap kolom.<\/span><\/p>\n

Untuk melakukan ini, kita dapat menyorot rentang sel A2:C11<\/strong> , lalu klik ikon pemformatan bersyarat<\/strong> di tab Beranda<\/strong> di sepanjang pita atas, lalu klik Aturan Baru<\/strong> di menu tarik-turun:<\/span> <\/p>\n

\"\"<\/p>\n

Di jendela baru yang muncul, klik Gunakan rumus untuk menentukan sel mana yang akan diformat<\/strong> , lalu masukkan rumus berikut:<\/span><\/p>\n

 =COUNTIFS($A$2:$A$11,$A2,$B$2:$B$11,$B2,$C$2:$C$11,$C2) >1<\/strong><\/pre>\n
 Kemudian klik tombol Format<\/strong> dan pilih warna yang akan digunakan untuk pemformatan bersyarat.<\/span><\/p>\n
 Kami akan memilih hijau muda:<\/span> <\/p>\n
\"\"<\/p>\n
 Terakhir, klik OK<\/strong> .<\/span><\/p>\n
 Setiap baris duplikat dalam kumpulan data sekarang akan disorot:<\/span> <\/p>\n
\"Excel<\/p>\n
 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
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Excel: cara menyorot nilai maksimum di setiap baris<\/a>
 Excel: cara menyorot sel jika nilainya ada dalam daftar<\/a>
 Excel: Cara menyorot seluruh baris berdasarkan nilai sel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali, Anda mungkin ingin menyorot baris di Excel jika setiap nilai dalam baris merupakan duplikat dari baris lainnya. Untungnya, hal ini mudah dilakukan dengan menggunakan fitur Aturan Baru di Opsi Pemformatan Bersyarat . Contoh berikut menunjukkan cara melakukan hal ini. Contoh: Sorot Baris Duplikat di Excel Katakanlah kita memiliki kumpulan data berikut di Excel yang […]<\/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":"\nCara Menyorot Baris Duplikat di Excel (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyorot baris duplikat di Excel, dengan contoh lengkap.\" \/>\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-baris-duplikat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menyorot Baris Duplikat di Excel (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyorot baris duplikat di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T14:59:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hdup1.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-baris-duplikat\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/\",\"name\":\"Cara Menyorot Baris Duplikat di Excel (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T14:59:13+00:00\",\"dateModified\":\"2023-07-08T14:59:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyorot baris duplikat di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menyorot baris duplikat 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 Menyorot Baris Duplikat di Excel (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara menyorot baris duplikat di Excel, dengan contoh lengkap.","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-baris-duplikat\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menyorot Baris Duplikat di Excel (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara menyorot baris duplikat di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/","og_site_name":"Statorials","article_published_time":"2023-07-08T14:59:13+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hdup1.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-baris-duplikat\/","url":"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/","name":"Cara Menyorot Baris Duplikat di Excel (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T14:59:13+00:00","dateModified":"2023-07-08T14:59:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyorot baris duplikat di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menyorot baris duplikat 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\/4721"}],"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=4721"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4721\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}