{"id":3298,"date":"2023-07-18T05:24:35","date_gmt":"2023-07-18T05:24:35","guid":{"rendered":"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/"},"modified":"2023-07-18T05:24:35","modified_gmt":"2023-07-18T05:24:35","slug":"bandingkan-tiga-kolom-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/","title":{"rendered":"Cara membandingkan tiga kolom di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus dasar berikut untuk membandingkan tiga kolom di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(AND( <span style=\"color: #3366ff;\">B2<\/span> = <span style=\"color: #ff0000;\">C2<\/span> , <span style=\"color: #ff0000;\">C2<\/span> = <span style=\"color: #800080;\">D2<\/span> ),\"Equal\",\"Not Equal\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini membandingkan nilai dalam sel <strong>B2<\/strong> , <strong>C2<\/strong> , dan <strong>D2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika semua nilainya sama, rumus akan mengembalikan <strong>Equal<\/strong> . Jika tidak, ia akan mengembalikan <strong>Not Equal<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Bandingkan tiga kolom di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan pencetak gol terbanyak dari berbagai tim bola basket dalam tiga pertandingan berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27905 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exceltrois1.jpg\" alt=\"\" width=\"483\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut ke dalam sel <strong>E2<\/strong> untuk menguji apakah ketiga nilai di baris pertama semuanya sama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(AND( <span style=\"color: #3366ff;\">B2<\/span> = <span style=\"color: #ff0000;\">C2<\/span> , <span style=\"color: #ff0000;\">C2<\/span> = <span style=\"color: #800080;\">D2<\/span> ),\"Equal\",\"Not Equal\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-27906\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exceltrois2.jpg\" alt=\"Excel membandingkan tiga kolom\" width=\"569\" height=\"510\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Rumusnya mengembalikan <strong>Not Equal<\/strong> karena tidak ketiga nama di baris pertama cocok.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret rumus ini dari sel <strong>E2<\/strong> ke sel lainnya di kolom E untuk menguji kecocokan di setiap baris:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27907 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exceltrois3.jpg\" alt=\"\" width=\"468\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa rumus hanya mengembalikan <strong>Equal<\/strong> untuk baris yang nilai selnya sama di masing-masing dari tiga kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda juga dapat menerapkan pemformatan bersyarat pada baris yang ketiga nilai selnya sama dengan menyorot rentang sel <strong>E2:E11<\/strong> , lalu klik tombol <strong>Conditional Formatting<\/strong> pada tab Beranda, lalu klik <strong>Klik Sorot Aturan Sel<\/strong> , lalu klik <strong>Sama dengan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27908 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exceltrois3-1.jpg\" alt=\"\" width=\"592\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, ketik <strong>Equal<\/strong> di dalam kotak dan pilih warna isian, lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27909 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exceltrois4.jpg\" alt=\"\" width=\"674\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Baris dengan nilai yang cocok di ketiga kolom sekarang akan diisi dengan warna hijau:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27910 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exceltrois5.jpg\" alt=\"\" width=\"493\" height=\"446\" srcset=\"\" sizes=\"\"><\/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\/vlookup-membandingkan-dua-daftar\/\" target=\"_blank\" rel=\"noopener\">Cara Membandingkan Dua Daftar di Excel Menggunakan VLOOKUP<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bandingkan-lembar-excel-untuk-mengetahui-perbedaannya\/\" target=\"_blank\" rel=\"noopener\">Bagaimana Membandingkan Dua Lembar Excel untuk Perbedaan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-membandingkan-tanggal-tanpa-waktu\/\" target=\"_blank\" rel=\"noopener\">Bagaimana membandingkan tanggal tanpa waktu di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus dasar berikut untuk membandingkan tiga kolom di Excel: =IF(AND( B2 = C2 , C2 = D2 ),&#8221;Equal&#8221;,&#8221;Not Equal&#8221;) Rumus khusus ini membandingkan nilai dalam sel B2 , C2 , dan D2 . Jika semua nilainya sama, rumus akan mengembalikan Equal . Jika tidak, ia akan mengembalikan Not Equal . Contoh berikut [&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 Tiga Kolom di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membandingkan tiga kolom di Excel, dengan contoh langkah demi langkah.\" \/>\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\/bandingkan-tiga-kolom-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membandingkan Tiga Kolom di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membandingkan tiga kolom di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T05:24:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exceltrois1.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\/bandingkan-tiga-kolom-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/\",\"name\":\"Cara Membandingkan Tiga Kolom di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T05:24:35+00:00\",\"dateModified\":\"2023-07-18T05:24:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membandingkan tiga kolom di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membandingkan tiga kolom 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 Tiga Kolom di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara membandingkan tiga kolom di Excel, dengan contoh langkah demi langkah.","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\/bandingkan-tiga-kolom-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membandingkan Tiga Kolom di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membandingkan tiga kolom di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-18T05:24:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exceltrois1.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\/bandingkan-tiga-kolom-di-excel\/","url":"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/","name":"Cara Membandingkan Tiga Kolom di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T05:24:35+00:00","dateModified":"2023-07-18T05:24:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membandingkan tiga kolom di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bandingkan-tiga-kolom-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membandingkan tiga kolom 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\/3298"}],"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=3298"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3298\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}