{"id":4441,"date":"2023-07-11T02:20:18","date_gmt":"2023-07-11T02:20:18","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/"},"modified":"2023-07-11T02:20:18","modified_gmt":"2023-07-11T02:20:18","slug":"google-sheet-periksa-apakah-ada-nilai-di-kolom-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/","title":{"rendered":"Google spreadsheet: periksa apakah ada nilai kolom di kolom lain"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk memeriksa apakah ada nilai kolom di kolom lain di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=NOT(ISERROR(MATCH( <span style=\"color: #ff6600;\">A2<\/span> , <span style=\"color: #800080;\">$B$2:$B$16<\/span> , <span style=\"color: #3366ff;\">0<\/span> )))<\/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 Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Sheets, di mana 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-34782 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ve1.png\" alt=\"\" width=\"507\" height=\"453\" 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: #ff6600;\">A2<\/span> , <span style=\"color: #800080;\">$B$2:$B$16<\/span> , <span style=\"color: #3366ff;\">0<\/span> )))<\/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=\" wp-image-34783 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ve2.png\" alt=\"\" width=\"557\" height=\"449\" 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: #ff6600;\">A2<\/span> , <span style=\"color: #800080;\">$B$2:$B$16<\/span> , <span style=\"color: #3366ff;\">0<\/span> ))), \u201c <span style=\"color: #008000;\">Yes<\/span> \u201d, \u201c <span style=\"color: #008000;\">No<\/span> \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-34784 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ve3.png\" alt=\"\" width=\"564\" height=\"470\" 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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara memeriksa apakah beberapa sel sama<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara memeriksa apakah nilainya berada dalam jangkauan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-sel-berisi-teks-daftar\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Periksa apakah sel berisi teks daftar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk memeriksa apakah ada nilai kolom di kolom lain di Google Spreadsheet: =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 [&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>Google Spreadsheet: 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 Google Sheets, 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\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: 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 Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T02:20:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ve1.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\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/\",\"name\":\"Google Spreadsheet: Periksa apakah ada nilai kolom di kolom lain - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T02:20:18+00:00\",\"dateModified\":\"2023-07-11T02:20:18+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 Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: 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":"Google Spreadsheet: Periksa apakah ada nilai kolom di kolom lain - Statologi","description":"Tutorial ini menjelaskan cara memeriksa apakah nilai kolom ada di kolom lain di Google Sheets, 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\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Periksa apakah ada nilai kolom di kolom lain - Statologi","og_description":"Tutorial ini menjelaskan cara memeriksa apakah nilai kolom ada di kolom lain di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-11T02:20:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ve1.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\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/","url":"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/","name":"Google Spreadsheet: Periksa apakah ada nilai kolom di kolom lain - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T02:20:18+00:00","dateModified":"2023-07-11T02:20:18+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 Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-periksa-apakah-ada-nilai-di-kolom-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: 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\/4441"}],"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=4441"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4441\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}