{"id":3926,"date":"2023-07-14T17:15:27","date_gmt":"2023-07-14T17:15:27","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/"},"modified":"2023-07-14T17:15:27","modified_gmt":"2023-07-14T17:15:27","slug":"google-sheet-menemukan-duplikat-dalam-dua-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/","title":{"rendered":"Google sheets: cara menemukan duplikat dalam dua kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda sering kali ingin menemukan nilai duplikat dalam dua kolom di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan pemformatan bersyarat dengan fungsi <strong>COUNTIF()<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menemukan nilai duplikat dalam dua kolom kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-31572\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dupdeux1.jpg\" alt=\"Google Sheets memeriksa duplikat dalam dua kolom\" width=\"476\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Temukan duplikat dalam dua kolom di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dua kolom berikut di Google Sheets yang berisi nama pemain bola basket dari dua tim:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31573 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dupdeux2.jpg\" alt=\"\" width=\"485\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin menyorot nama duplikat di kedua kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat menyorot sel dalam rentang <strong>A2:B9<\/strong> , lalu klik tab <strong>Format<\/strong> , lalu <strong>Conditional Formatting<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31574 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/duptwo3.jpg\" alt=\"\" width=\"567\" height=\"527\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Aturan Format Bersyarat<\/strong> yang muncul, klik menu tarik-turun di bawah <strong>Format Sel Jika<\/strong> dan pilih <strong>Rumus Khusus<\/strong> , lalu ketikkan rumus berikut:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF($A$2:$B$9,A2)&gt;1<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31575 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dupdeux4.jpg\" alt=\"\" width=\"347\" height=\"691\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Selesai<\/strong> , nilai duplikat yang muncul di kedua kolom akan disorot dengan warna hijau:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-31572\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dupdeux1.jpg\" alt=\"Google Sheets memeriksa duplikat dalam dua kolom\" width=\"476\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat melihat bahwa nama-nama berikut merupakan duplikat di kedua kolom:<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">andi<\/span><\/li>\n<li> <span style=\"color: #000000;\">anak<\/span><\/li>\n<li> <span style=\"color: #000000;\">Franc<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Masing-masing nama ini muncul di kedua kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa secara default, Google Spreadsheet menggunakan latar belakang hijau muda untuk pemformatan bersyarat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda dapat mengubah warna latar belakang, warna font, dan gaya font pemformatan bersyarat untuk memformat nilai duplikat sesuai keinginan Anda.<\/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> <a href=\"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIF terdapat di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIF dengan wildcard di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-sel-dengan-teks\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung sel dengan teks di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda sering kali ingin menemukan nilai duplikat dalam dua kolom di Google Spreadsheet. Untungnya, hal ini mudah dilakukan menggunakan pemformatan bersyarat dengan fungsi COUNTIF() . Contoh berikut menunjukkan cara menemukan nilai duplikat dalam dua kolom kumpulan data berikut di Google Spreadsheet: Ayo pergi! Contoh: Temukan duplikat dalam dua kolom di Google Spreadsheet Misalkan kita memiliki [&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 duplikat dalam dua kolom \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menemukan nilai duplikat di dua kolom 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\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/\" \/>\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 duplikat dalam dua kolom \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menemukan nilai duplikat di dua kolom di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T17:15:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dupdeux1.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\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/\",\"name\":\"Google Spreadsheet: Cara menemukan duplikat dalam dua kolom \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T17:15:27+00:00\",\"dateModified\":\"2023-07-14T17:15:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menemukan nilai duplikat di dua kolom di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara menemukan duplikat dalam dua kolom\"}]},{\"@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 duplikat dalam dua kolom \u2013 Statorial","description":"Tutorial ini menjelaskan cara menemukan nilai duplikat di dua kolom 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\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menemukan duplikat dalam dua kolom \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menemukan nilai duplikat di dua kolom di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-14T17:15:27+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dupdeux1.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\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/","url":"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/","name":"Google Spreadsheet: Cara menemukan duplikat dalam dua kolom \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T17:15:27+00:00","dateModified":"2023-07-14T17:15:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menemukan nilai duplikat di dua kolom di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menemukan-duplikat-dalam-dua-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara menemukan duplikat dalam dua kolom"}]},{"@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\/3926"}],"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=3926"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3926\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}