{"id":4673,"date":"2023-07-09T02:13:14","date_gmt":"2023-07-09T02:13:14","guid":{"rendered":"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/"},"modified":"2023-07-09T02:13:14","modified_gmt":"2023-07-09T02:13:14","slug":"bandingkan-empat-kolom-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/","title":{"rendered":"Cara membandingkan empat 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 empat 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 style=\"color: #000000;\">= <span style=\"color: #800080;\">D2<\/span><\/span><\/span> <span style=\"color: #000000;\">, <span style=\"color: #800080;\">D2<\/span> = <span style=\"color: #008000;\">E2<\/span><\/span> ),\u201cEqual\",\"Not Equal\u201d)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini membandingkan nilai dalam sel <strong>B2<\/strong> , <strong>C2<\/strong> , <strong>D2<\/strong> , dan <strong>E2<\/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 empat 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 empat pertandingan berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36479 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compa1.png\" alt=\"\" width=\"490\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut ke dalam sel <b>F2<\/b> untuk menguji apakah keempat 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 style=\"color: #000000;\">= <span style=\"color: #800080;\">D2<\/span><\/span><\/span> <span style=\"color: #000000;\">, <span style=\"color: #800080;\">D2<\/span> = <span style=\"color: #008000;\">E2<\/span><\/span> ),\u201cEqual\",\"Not Equal\u201d)<\/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=\" wp-image-36480 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compa2.png\" alt=\"\" width=\"552\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus yang dikembalikan <strong>Tidak Sama<\/strong> karena tidak keempat nama di baris pertama cocok.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret rumus ini dari sel <strong>F2<\/strong> ke sel lainnya di kolom F untuk menguji kecocokan di setiap baris:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36481\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compa3.png\" alt=\"Excel membandingkan empat kolom\" width=\"604\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa rumusnya hanya mengembalikan <strong>Equal<\/strong> untuk baris yang nilai selnya sama di keempat kolomnya.<\/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>F2:F11<\/strong> , lalu klik tombol <strong>Pemformatan Bersyarat<\/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-36482 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compa4.png\" alt=\"\" width=\"601\" height=\"398\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Baris dengan nilai yang cocok di keempat kolom sekarang akan diisi dengan warna hijau:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36483 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compa5.png\" alt=\"\" width=\"538\" height=\"418\" 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 empat kolom di Excel: =IF(AND( B2 = C2 , C2 = D2 , D2 = E2 ),\u201cEqual&#8221;,&#8221;Not Equal\u201d) Rumus khusus ini membandingkan nilai dalam sel B2 , C2 , D2 , dan E2 . Jika semua nilainya sama, rumus akan mengembalikan Equal . Jika tidak, ia akan [&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 Empat Kolom di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membandingkan empat kolom di Excel, 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\/bandingkan-empat-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 Empat Kolom di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membandingkan empat kolom di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T02:13:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compa1.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\/bandingkan-empat-kolom-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/\",\"name\":\"Cara Membandingkan Empat Kolom di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T02:13:14+00:00\",\"dateModified\":\"2023-07-09T02:13:14+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membandingkan empat kolom di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membandingkan empat 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 Empat Kolom di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara membandingkan empat kolom di Excel, 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\/bandingkan-empat-kolom-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membandingkan Empat Kolom di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membandingkan empat kolom di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-09T02:13:14+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compa1.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\/bandingkan-empat-kolom-di-excel\/","url":"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/","name":"Cara Membandingkan Empat Kolom di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T02:13:14+00:00","dateModified":"2023-07-09T02:13:14+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membandingkan empat kolom di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bandingkan-empat-kolom-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membandingkan empat 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\/4673"}],"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=4673"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4673\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}