{"id":1061,"date":"2012-10-24T23:31:29","date_gmt":"2012-10-24T15:31:29","guid":{"rendered":"http:\/\/rais.my\/blog\/?p=1061"},"modified":"2012-10-24T23:31:29","modified_gmt":"2012-10-24T15:31:29","slug":"mencari-padanan-data-antara-dua-lajur-microsoft-excel","status":"publish","type":"post","link":"https:\/\/rais.my\/blog\/mencari-padanan-data-antara-dua-lajur-microsoft-excel\/","title":{"rendered":"Mencari padanan data antara dua lajur &#8211; Microsoft Excel"},"content":{"rendered":"<p>Assalam,<\/p>\n<p>Mungkin ada menghadapi situasa di mana mempunyai beribu-ribu data dan perlu mencari sama ada data tersebut sudah terdapat atau belum pada tempat tertentu. Atau anda terpaksa mencari data yang duplicate atau serupa.<\/p>\n<p>Di sini saya kongsi cara menggunakan Microsoft Excel dalam mencari data yang bertindih atau serupa. Formula yang terlibat ialah:<\/p>\n<p>=IF(ISERROR(MATCH(A1,$B$1:$B$6,0)),&#8221;Tiada Padanan&#8221;,&#8221;Padan&#8221;)<\/p>\n<p>Nota :<br \/>\nA1 = Field data yang ingin dipadankan<br \/>\n$B$1:$B$6 atau B1:B6 = Julat untuk padanan<br \/>\n0 = match-type, mencari padanan yang serupa<\/p>\n<p>Lihat gambarajah bawah;<\/p>\n<p><a href=\"http:\/\/rais.my\/blog\/mencari-padanan-data-antara-dua-lajur-microsoft-excel\/excel-data-compare\/\" rel=\"attachment wp-att-1062\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/rais.my\/blog\/wp-content\/uploads\/2012\/10\/excel-data-compare-300x83.png\"  alt=\"excel-data-compare-300x83 Mencari padanan data antara dua lajur - Microsoft Excel\"   title=\"\"  width=\"300\" height=\"83\" class=\"alignnone size-medium wp-image-1062\" srcset=\"https:\/\/rais.my\/blog\/wp-content\/uploads\/2012\/10\/excel-data-compare-300x83.png 300w, https:\/\/rais.my\/blog\/wp-content\/uploads\/2012\/10\/excel-data-compare-1024x283.png 1024w, https:\/\/rais.my\/blog\/wp-content\/uploads\/2012\/10\/excel-data-compare.png 1275w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/rais.my\">rais.my<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Assalam, Mungkin ada menghadapi situasa di mana mempunyai beribu-ribu data dan perlu mencari sama ada data tersebut sudah terdapat atau belum pada tempat tertentu. Atau anda terpaksa mencari data yang duplicate atau serupa. Di sini saya kongsi cara menggunakan Microsoft Excel dalam mencari data yang bertindih atau serupa. Formula yang terlibat ialah: =IF(ISERROR(MATCH(A1,$B$1:$B$6,0)),&#8221;Tiada Padanan&#8221;,&#8221;Padan&#8221;) Nota [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cybocfi_hide_featured_image":"","footnotes":""},"categories":[87,532,1],"tags":[567,268,520,569,566,519,518,565,568],"class_list":["post-1061","post","type-post","status-publish","format-standard","hentry","category-diy","category-tip","category-umum","tag-compare","tag-data","tag-excel","tag-find-duplicates","tag-lajur","tag-microsoft","tag-ms-excel","tag-padanan","tag-two-columns"],"_links":{"self":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1061","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/comments?post=1061"}],"version-history":[{"count":2,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1061\/revisions"}],"predecessor-version":[{"id":1064,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1061\/revisions\/1064"}],"wp:attachment":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/media?parent=1061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/categories?post=1061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/tags?post=1061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}