{"id":2150,"date":"2023-09-28T21:42:37","date_gmt":"2023-09-28T21:42:37","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/pertandingan-2\/"},"modified":"2023-12-06T06:16:41","modified_gmt":"2023-12-06T06:16:41","slug":"pertandingan-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/pertandingan-2\/","title":{"rendered":"Bagaimana cara menggunakan fungsi pencocokan di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2960562926\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Ada fungsi di VBA yang dapat Anda gunakan, tetapi Anda tidak dapat menggunakan fungsi apa pun yang setara dengan MATCH. Namun ada cara yang bisa kita gunakan untuk menggunakan fungsi tersebut. Di VBA, terdapat <a href=\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/\">properti WorksheetFunction<\/a> yang dapat membantu Anda mengakses fungsi lembar kerja untuk digunakan dalam makro.<\/p><h2 class=\"wp-block-heading\"> Menggunakan Pencocokan di VBA<\/h2><p> Seperti yang saya katakan, kita akan menggunakan fungsi spreadsheet di makro, tetapi ada satu hal yang perlu Anda perhatikan ketika Anda menggunakan fungsi spreadsheet dengan benar, ini tidak akan menampilkan nama argumen dalam fungsi tersebut, jadi pastikan untuk memeriksa semua argumen yang perlu kita tentukan dalam pertandingan. Di bawah ini adalah contoh pengambilan gambar untuk referensi Anda. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62175\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi pertandingan-di-vba\" width=\"516\" height=\"155\"><\/figure><\/div><p> Berikut adalah contoh di mana kita memiliki daftar nomor acak, dan Anda harus mencocokkan nomor &#8220;943&#8221;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62176\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-numeros-aleatoires.png\" sizes=\"auto, \" srcset=\"\" alt=\"nomor acak\" width=\"171\" height=\"236\"><\/figure><\/div><p> Sekarang buka <a href=\"https:\/\/exceladvisor.org\/id\/editor-visual-dasar\/\">Editor Visual Basic<\/a> , masukkan <a href=\"https:\/\/exceladvisor.org\/id\/modul\/\">modul<\/a> baru dan ikuti langkah-langkah di bawah ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"B1\") = WorksheetFunction.Match(943, Range(\"A:A\"), 0)<\/code><\/pre><ol type=\"1\"><li> Masuk ke properti lembar kerja dan ketikkan titik untuk mendapatkan daftar fungsi.<\/li><li> Pilih fungsi pencocokan atau Anda juga bisa memasukkannya.<\/li><li> Ketikkan tanda kurung buka untuk menentukan argumen.<\/li><li> Dalam argumen, Anda harus menentukan nilai yang akan dicari, rentang yang akan diperiksa, dan jenis pencocokan.<\/li><li> Pada akhirnya, gunakan referensi sel untuk mendapatkan hasil fungsinya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62177\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vba-pour-la-fonction-match.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi vba-untuk-pertandingan\" width=\"672\" height=\"444\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/rata-rata-2\/\">Nilai rata-rata di Excel dengan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-hari-ini-waktu-saat-ini\/\">Dapatkan tanggal hari ini dan waktu saat ini menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-1\/\">Jumlahkan nilai di Excel menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/modus-1\/\">MOD di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/\">Fungsi lembar kerja VBA<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2150","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menggunakan fungsi pencocokan di VBA?<\/title>\n<meta name=\"description\" content=\"Ada fungsi di VBA yang dapat Anda gunakan, tetapi Anda tidak dapat menggunakan fungsi apa pun yang setara dengan MATCH.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan fungsi pencocokan di VBA?\" \/>\n<meta property=\"og:description\" content=\"Ada fungsi di VBA yang dapat Anda gunakan, tetapi Anda tidak dapat menggunakan fungsi apa pun yang setara dengan MATCH.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/\",\"name\":\"Bagaimana cara menggunakan fungsi pencocokan di VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png\",\"datePublished\":\"2023-09-28T21:42:37+00:00\",\"dateModified\":\"2023-12-06T06:16:41+00:00\",\"description\":\"Ada fungsi di VBA yang dapat Anda gunakan, tetapi Anda tidak dapat menggunakan fungsi apa pun yang setara dengan MATCH.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan fungsi pencocokan di vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menggunakan fungsi pencocokan di VBA?","description":"Ada fungsi di VBA yang dapat Anda gunakan, tetapi Anda tidak dapat menggunakan fungsi apa pun yang setara dengan MATCH.","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:\/\/exceladvisor.org\/id\/pertandingan-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan fungsi pencocokan di VBA?","og_description":"Ada fungsi di VBA yang dapat Anda gunakan, tetapi Anda tidak dapat menggunakan fungsi apa pun yang setara dengan MATCH.","og_url":"https:\/\/exceladvisor.org\/id\/pertandingan-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/pertandingan-2\/","url":"https:\/\/exceladvisor.org\/id\/pertandingan-2\/","name":"Bagaimana cara menggunakan fungsi pencocokan di VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/pertandingan-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/pertandingan-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png","datePublished":"2023-09-28T21:42:37+00:00","dateModified":"2023-12-06T06:16:41+00:00","description":"Ada fungsi di VBA yang dapat Anda gunakan, tetapi Anda tidak dapat menggunakan fungsi apa pun yang setara dengan MATCH.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/pertandingan-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/pertandingan-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/pertandingan-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/pertandingan-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan fungsi pencocokan di vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2150"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2150\/revisions"}],"predecessor-version":[{"id":2551,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2150\/revisions\/2551"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}