{"id":4123,"date":"2023-07-13T10:43:33","date_gmt":"2023-07-13T10:43:33","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/"},"modified":"2023-07-13T10:43:33","modified_gmt":"2023-07-13T10:43:33","slug":"excel-memeriksa-apakah-nilainya-ada-di-kolom-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/","title":{"rendered":"Excel: periksa apakah ada nilai kolom di kolom lain"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk memeriksa apakah nilai kolom ada di kolom lain di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=NOT(ISERROR(MATCH( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">$B$2:$B$16<\/span> ,0)))<\/strong>\n<\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini memeriksa apakah nilai di sel <strong>A2<\/strong> ada dalam rentang <strong>B2:B16<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika ada dalam rentang <strong>B2:B16<\/strong> , rumus akan mengembalikan <strong>TRUE<\/strong> . Jika tidak, ia akan mengembalikan <strong>FALSE<\/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: Periksa apakah ada nilai kolom di kolom lain di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel, dimana satu kolom berisi daftar bahan makanan yang dibutuhkan dan kolom lainnya berisi daftar bahan makanan yang tersedia di toko:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32761 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/existe1.png\" alt=\"\" width=\"483\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin memeriksa apakah setiap item di kolom <strong>Daftar Belanjaan<\/strong> juga ada di kolom <strong>Inventaris Belanjaan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=NOT(ISERROR(MATCH( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">$B$2:$B$16<\/span> ,0)))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32762\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/existe2.png\" alt=\"Excel memeriksa apakah nilai kolom ada di kolom lain\" width=\"540\" height=\"503\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C menunjukkan apakah setiap sel di kolom A juga ada di kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Apel<\/strong> ada di inventaris toko kelontong.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><b>Pisang<\/b> ada di persediaan toko kelontong.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Wortel<\/strong> tidak ada di persediaan toko kelontong.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Pir<\/strong> ada di inventaris toko kelontong.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Paprika<\/strong> tidak ada di inventaris toko kelontong.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jika Anda ingin mengembalikan nilai selain TRUE dan FALSE, Anda bisa menggabungkan rumus dalam fungsi <strong>IF<\/strong> dan menentukan nilai yang ingin Anda kembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita bisa menggunakan rumus berikut untuk menghasilkan &#8220;Ya&#8221; atau &#8220;Tidak&#8221; dan bukan TRUE atau FALSE:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(NOT(ISERROR(MATCH( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">$B$2:$B$16<\/span> ,0))), \"Yes\", \"No\")<\/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-32763 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/existe3.png\" alt=\"\" width=\"621\" height=\"486\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya sekarang mengembalikan &#8220;Ya&#8221; jika item <strong>daftar belanjaan<\/strong> ada di <strong>Inventaris Bahan Makanan<\/strong> atau &#8220;Tidak&#8221; jika tidak ada.<\/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-memeriksa-apakah-rentang-tersebut-berisi-nilai\/\" target=\"_blank\" rel=\"noopener\">Cara memeriksa apakah rentang berisi nilai tertentu di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-berisi-teks-daftar\/\" target=\"_blank\" rel=\"noopener\">Cara memeriksa apakah sel berisi teks daftar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-sel-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata jika sel berisi teks di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk memeriksa apakah nilai kolom ada di kolom lain di Excel: =NOT(ISERROR(MATCH( A2 , $B$2:$B$16 ,0))) Rumus khusus ini memeriksa apakah nilai di sel A2 ada dalam rentang B2:B16 . Jika ada dalam rentang B2:B16 , rumus akan mengembalikan TRUE . Jika tidak, ia akan mengembalikan FALSE . 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>Excel: Periksa apakah ada nilai kolom di kolom lain - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah nilai kolom ada di kolom lain 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\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Periksa apakah ada nilai kolom di kolom lain - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah nilai kolom ada di kolom lain di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T10:43:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/existe1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/\",\"name\":\"Excel: Periksa apakah ada nilai kolom di kolom lain - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T10:43:33+00:00\",\"dateModified\":\"2023-07-13T10:43:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memeriksa apakah nilai kolom ada di kolom lain di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: periksa apakah ada nilai kolom di kolom lain\"}]},{\"@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":"Excel: Periksa apakah ada nilai kolom di kolom lain - Statologi","description":"Tutorial ini menjelaskan cara memeriksa apakah nilai kolom ada di kolom lain 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\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Periksa apakah ada nilai kolom di kolom lain - Statologi","og_description":"Tutorial ini menjelaskan cara memeriksa apakah nilai kolom ada di kolom lain di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-13T10:43:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/existe1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/","url":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/","name":"Excel: Periksa apakah ada nilai kolom di kolom lain - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T10:43:33+00:00","dateModified":"2023-07-13T10:43:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memeriksa apakah nilai kolom ada di kolom lain di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-nilainya-ada-di-kolom-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: periksa apakah ada nilai kolom di kolom lain"}]},{"@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\/4123"}],"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=4123"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4123\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}