{"id":4724,"date":"2023-07-08T14:23:19","date_gmt":"2023-07-08T14:23:19","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/"},"modified":"2023-07-08T14:23:19","modified_gmt":"2023-07-08T14:23:19","slug":"excel-membandingkan-dua-tabel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/","title":{"rendered":"Cara membandingkan dua tabel di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membandingkan dua tabel di Excel untuk mendeteksi perbedaan.<\/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: Bandingkan dua tabel di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai dua tabel berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36888 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptwo1.png\" alt=\"\" width=\"602\" height=\"395\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menyorot perbedaan sel terkait antara kedua tabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat menyorot rentang sel <strong>F2:H11<\/strong> , lalu klik ikon <strong>pemformatan bersyarat<\/strong> di tab <strong>Beranda<\/strong> di sepanjang pita atas, lalu klik <strong>Aturan Baru<\/strong> di menu tarik-turun:<\/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>=A2&lt;&gt;F2<\/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 merah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36889 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptwo2.png\" alt=\"\" width=\"672\" height=\"547\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik <strong>OK<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setiap nilai di tabel kedua yang tidak cocok dengan nilai terkait di tabel pertama kini disorot dengan warna merah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36890\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptwo3.png\" alt=\"Excel membandingkan dua tabel untuk mengetahui perbedaannya\" width=\"600\" height=\"327\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam contoh ini, kami memilih untuk menggunakan isian merah 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> <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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membandingkan dua tabel di Excel untuk mendeteksi perbedaan. Untungnya, hal ini mudah dilakukan dengan menggunakan fitur Aturan Baru di Opsi Pemformatan Bersyarat . Contoh berikut menunjukkan cara melakukan hal ini. Contoh: Bandingkan dua tabel di Excel Misalkan kita mempunyai dua tabel berikut di Excel yang berisi informasi tentang berbagai pemain bola [&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>Cara Membandingkan Dua Tabel di Excel (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membandingkan dua tabel di Excel untuk mendeteksi perbedaan, termasuk contoh lengkapnya.\" \/>\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-membandingkan-dua-tabel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membandingkan Dua Tabel di Excel (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membandingkan dua tabel di Excel untuk mendeteksi perbedaan, termasuk contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T14:23:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptwo1.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-membandingkan-dua-tabel\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/\",\"name\":\"Cara Membandingkan Dua Tabel di Excel (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T14:23:19+00:00\",\"dateModified\":\"2023-07-08T14:23:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membandingkan dua tabel di Excel untuk mendeteksi perbedaan, termasuk contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membandingkan dua tabel 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 Membandingkan Dua Tabel di Excel (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara membandingkan dua tabel di Excel untuk mendeteksi perbedaan, termasuk contoh lengkapnya.","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-membandingkan-dua-tabel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membandingkan Dua Tabel di Excel (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara membandingkan dua tabel di Excel untuk mendeteksi perbedaan, termasuk contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/","og_site_name":"Statorials","article_published_time":"2023-07-08T14:23:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptwo1.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-membandingkan-dua-tabel\/","url":"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/","name":"Cara Membandingkan Dua Tabel di Excel (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T14:23:19+00:00","dateModified":"2023-07-08T14:23:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membandingkan dua tabel di Excel untuk mendeteksi perbedaan, termasuk contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membandingkan dua tabel 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\/4724"}],"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=4724"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4724\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}