{"id":1748,"date":"2023-11-07T16:11:29","date_gmt":"2023-11-07T16:11:29","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/"},"modified":"2023-12-06T06:13:07","modified_gmt":"2023-12-06T06:13:07","slug":"membandingkan-kolom","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/","title":{"rendered":"Bagaimana cara membandingkan dua kolom di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1987439499\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di Excel, pemformatan bersyarat adalah cara termudah untuk membandingkan dua kolom. Dengan ini Anda dapat membandingkan dua kolom dalam beberapa cara. Dalam tutorial ini, kita akan mempelajari beberapa metode menggunakan pemformatan bersyarat untuk perbandingan kolom.<\/p><h2 class=\"wp-block-heading\"> Bandingkan dua kolom per baris<\/h2><p> Dengan metode ini, Anda dapat membandingkan dua sel di setiap baris kolom dan menyorot sel dengan nilai yang sama.<\/p><ol><li> Pertama, pilih kedua kolom di data. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-pilih-kedua-kolom\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"1-select-both-columns\" width=\"290\" height=\"335\"><\/li><li> Selanjutnya, buka tab Beranda &gt; Pemformatan Bersyarat &gt; Aturan Baru. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-pemformatan-bersyarat-aturan baru\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-nouvelle-regle-de-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-conditional-formatting-new-rule\" width=\"296\" height=\"397\"><\/li><li> Dari sana, klik \u201cGunakan rumus untuk menentukan sel mana yang akan diformat.\u201d <br><img loading=\"lazy\" decoding=\"async\" title=\"3-pilih-gunakan-rumus-untuk-menentukan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionnez-utiliser-une-formule-pour-determiner.png\" sizes=\"auto, \" srcset=\"\" alt=\"3-select-use-a-formula-to-determine\" width=\"563\" height=\"202\"><\/li><li> Selanjutnya, pada formula bar, masukkan rumus =$A2&lt;&gt;$B2, lalu klik \u201cFormat\u2026\u201d untuk menentukan format. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-masukkan-rumus-dan-tentukan-format-formatnya\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-entrez-la-formule-et-specifiez-le-format.png\" sizes=\"auto, \" srcset=\"\" alt=\"4-enter-formula-and-specify-format\" width=\"565\" height=\"209\"><\/li><li> Setelah Anda menentukan formatnya, klik OK untuk menerapkan pemformatan bersyarat dan OK lagi untuk menutup Rules Manager. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-tutup-manajer-aturan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-fermer-le-gestionnaire-de-regles.png\" sizes=\"auto, \" srcset=\"\" alt=\"5-close-the-rules-manager\" width=\"580\" height=\"217\"><\/li><\/ol><p> Dan saat Anda mengklik OK, itu menyorot sel di kedua kolom yang nilainya sama. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90468\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-cellules-en-surbrillance-avec-les-memes-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"sel yang disorot dengan nilai yang sama\" width=\"280\" height=\"331\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Bandingkan semua nilai di semua kolom<\/h2><p> Berbeda dengan metode pertama, Anda dapat menyorot kedua nilai yang merupakan duplikat di kolom. Dan untuk itu, pilih kedua kolom dan buka tab Beranda &gt; Pemformatan Bersyarat &gt; Aturan Penyorotan Sel &gt; Nilai Duplikat. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90469\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-selectionner-les-valeurs-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih nilai duplikat\" width=\"530\" height=\"440\"><\/figure><\/div><p> Di kotak dialog Nilai Duplikat, pilih nilai yang ingin Anda sorot dan warna yang ingin Anda terapkan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90470\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-selectionnez-doublon-pour-mettre-en-surbrillance-les-doublons.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih-duplikat-untuk-menyorot-duplikat\" width=\"388\" height=\"160\"><\/figure><\/div><p> Pada akhirnya, klik OK untuk menerapkan pemformatan bersyarat. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90471\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-valeurs-en-double-mises-en-evidence.png\" sizes=\"auto, \" srcset=\"\" alt=\"menyoroti nilai duplikat\" width=\"285\" height=\"324\"><\/figure><\/div><p> Saat Anda mengklik OK, semua sel yang nilainya duplikat di kedua kolom akan disorot dengan format yang Anda pilih. Namun jika Anda ingin menyorot sel unik di kedua kolom, Anda harus memilih \u201cTunggal\u201d dari daftar drop-down. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90472\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-selectionnez-unique-pour-mettre-en-evidence-les-valeurs-uniques.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih-unik-untuk-menyorot-nilai-unik\" width=\"381\" height=\"156\"><\/figure><\/div><p> Dan ketika Anda mengklik OK, itu akan menyorot nilai-nilai unik menggunakan perbandingan di kedua kolom. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-90473\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-valeurs-uniques-mises-en-avant.png\" sizes=\"auto, \" srcset=\"\" alt=\"nilai tunggal yang disorot\" width=\"260\" height=\"311\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comparer-la-mise-en-forme-conditionnelle-des-colonnes.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-6076ba72 gb-container-mt\"> <a class=\"gb-button gb-button-76e6a499 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Pelajari dasar-dasar Excel<\/a><h2 class=\"gb-headline gb-headline-a9e9e206 gb-headline-text gb-headline-mt-heading\"> Pelajari lebih lanjut tentang <a href=\"https:\/\/exceladvisor.org\/id\/pemformatan-bersyarat\/\">pemformatan bersyarat<\/a> <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-790317cb gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-a9845ede\"><div class=\"gb-container gb-container-a9845ede\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menerapkan-pemformatan-bersyarat\/\">Terapkan pemformatan bersyarat ke tabel pivot<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menarik\/\">Hapus Pemformatan Bersyarat<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sel-kosong\/\">Terapkan Pemformatan Bersyarat pada Sel Kosong di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sel-lain\/\">Terapkan pemformatan bersyarat berdasarkan sel lain<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kolom-lain\/\">Terapkan pemformatan bersyarat berdasarkan kolom lain<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-ec8ff319\"><div class=\"gb-container gb-container-ec8ff319\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1748","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara membandingkan dua kolom di Excel? [Panduan 2023]<\/title>\n<meta name=\"description\" content=\"Tutorial ini membantu Anda membandingkan dua kolom menggunakan pemformatan bersyarat di Excel. Mari kita periksa ini\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membandingkan dua kolom di Excel? [Panduan 2023]\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini membantu Anda membandingkan dua kolom menggunakan pemformatan bersyarat di Excel. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/\",\"name\":\"Bagaimana cara membandingkan dua kolom di Excel? [Panduan 2023]\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png\",\"datePublished\":\"2023-11-07T16:11:29+00:00\",\"dateModified\":\"2023-12-06T06:13:07+00:00\",\"description\":\"Tutorial ini membantu Anda membandingkan dua kolom menggunakan pemformatan bersyarat di Excel. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membandingkan dua kolom di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara membandingkan dua kolom di Excel? [Panduan 2023]","description":"Tutorial ini membantu Anda membandingkan dua kolom menggunakan pemformatan bersyarat di Excel. Mari kita periksa ini\u2026","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:\/\/exceladvisor.org\/id\/membandingkan-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membandingkan dua kolom di Excel? [Panduan 2023]","og_description":"Tutorial ini membantu Anda membandingkan dua kolom menggunakan pemformatan bersyarat di Excel. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:07+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/","url":"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/","name":"Bagaimana cara membandingkan dua kolom di Excel? [Panduan 2023]","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png","datePublished":"2023-11-07T16:11:29+00:00","dateModified":"2023-12-06T06:13:07+00:00","description":"Tutorial ini membantu Anda membandingkan dua kolom menggunakan pemformatan bersyarat di Excel. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-les-deux-colonnes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membandingkan dua kolom di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1748","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1748"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1748\/revisions"}],"predecessor-version":[{"id":2267,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1748\/revisions\/2267"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}