{"id":5043,"date":"2023-07-04T16:10:30","date_gmt":"2023-07-04T16:10:30","guid":{"rendered":"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/"},"modified":"2023-07-04T16:10:30","modified_gmt":"2023-07-04T16:10:30","slug":"pencarian-excel-vs-temukan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/","title":{"rendered":"Excel: perbedaan antara fungsi search dan find"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Fungsi <strong>SEARCH<\/strong> dan <strong>FIND<\/strong> di Excel dapat digunakan untuk menemukan lokasi satu string teks di dalam string teks lainnya, namun ada dua perbedaan antara fungsi-fungsi ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1.<\/strong> Fungsi <strong>SEARCH<\/strong> tidak peka huruf besar-kecil sedangkan fungsi <strong>FIND<\/strong> peka huruf besar-kecil.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> Fungsi <strong>SEARCH<\/strong> mengizinkan wildcard sedangkan fungsi <strong>FIND<\/strong> tidak mengizinkan wildcard.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut mengilustrasikan dua perbedaan praktik tersebut dengan kolom nama tim bola basket berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39327 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sfind0.png\" alt=\"\" width=\"455\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: perbedaan peka huruf besar-kecil<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menggunakan <strong>SEARCH<\/strong> dan <strong>FIND<\/strong> untuk mengidentifikasi posisi huruf &#8220;s&#8221; pertama di setiap nama tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus berikut di sel <strong>B2<\/strong> dan <strong>C2<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">B2: <strong>=CARI(&#8220;s&#8221;, A2)<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">C2: <strong>=TEMUKAN(&#8220;s&#8221;, A2)<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kami kemudian akan mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B dan C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39328\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sfind2.png\" alt=\"Fungsi Excel SEARCH vs FIND peka huruf besar-kecil\" width=\"496\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>SEARCH<\/strong> tidak peka terhadap huruf besar-kecil, jadi fungsi ini hanya mencari posisi huruf &#8220;s&#8221; pertama pada setiap nama tim, apa pun huruf besarnya. Itu sebabnya dia mengembalikan <strong>1<\/strong> untuk <strong>Spurs<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, fungsi <strong>FIND<\/strong> peka terhadap huruf besar-kecil, sehingga menemukan posisi huruf kecil &#8220;s&#8221; pertama di setiap nama tim. Itu sebabnya dia mengembalikan <strong>5<\/strong> untuk <strong>Spurs<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Perbedaan antara wildcard<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menggunakan <strong>SEARCH<\/strong> dan <strong>FIND<\/strong> untuk mengidentifikasi posisi substring &#8220;rs&#8221; pertama di setiap nama tim di mana karakter apa pun dapat mendahului substring tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus berikut di sel <strong>B2<\/strong> dan <strong>C2<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">B2: <strong>=CARI(\u201c?rs\u201d, A2)<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">C2: <strong>=TEMUKAN(\u201c?rs\u201d, A2)<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kami kemudian akan mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B dan C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39330\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sfind3.png\" alt=\"Fungsi Excel SEARCH vs FIND dengan wildcard\" width=\"471\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>SEARCH<\/strong> memungkinkan wildcard, sehingga dapat menemukan posisi kemunculan pertama &#8220;rs&#8221; di setiap nama tim di mana karakter apa pun boleh mendahului &#8220;rs&#8221; karena penggunaan <strong>?<\/strong> karakter wildcard.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, fungsi <strong>FIND<\/strong> tidak mengizinkan wildcard. Itu sebabnya ia mengembalikan <strong>#VALUE!<\/strong> untuk setiap baris di kolom B.<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/fungsi-pencarian-excel-beberapa-nilai\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menggunakan Fungsi SEARCH untuk Menemukan Banyak Nilai<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/fungsi-pencarian-excel-dengan-banyak-kriteria\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggunakan fungsi FIND dengan beberapa kriteria<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-angka-pertama-dalam-string\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menemukan angka pertama dalam string teks<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fungsi SEARCH dan FIND di Excel dapat digunakan untuk menemukan lokasi satu string teks di dalam string teks lainnya, namun ada dua perbedaan antara fungsi-fungsi ini: 1. Fungsi SEARCH tidak peka huruf besar-kecil sedangkan fungsi FIND peka huruf besar-kecil. 2. Fungsi SEARCH mengizinkan wildcard sedangkan fungsi FIND tidak mengizinkan wildcard. Contoh berikut mengilustrasikan dua perbedaan [&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: perbedaan fungsi SEARCH dan FIND - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan perbedaan fungsi SEARCH dan FIND di Excel, beserta contohnya.\" \/>\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\/pencarian-excel-vs-temukan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: perbedaan fungsi SEARCH dan FIND - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan perbedaan fungsi SEARCH dan FIND di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T16:10:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sfind0.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\/pencarian-excel-vs-temukan\/\",\"url\":\"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/\",\"name\":\"Excel: perbedaan fungsi SEARCH dan FIND - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T16:10:30+00:00\",\"dateModified\":\"2023-07-04T16:10:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan perbedaan fungsi SEARCH dan FIND di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: perbedaan antara fungsi search dan find\"}]},{\"@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: perbedaan fungsi SEARCH dan FIND - Statologi","description":"Tutorial ini menjelaskan perbedaan fungsi SEARCH dan FIND di Excel, beserta contohnya.","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\/pencarian-excel-vs-temukan\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: perbedaan fungsi SEARCH dan FIND - Statologi","og_description":"Tutorial ini menjelaskan perbedaan fungsi SEARCH dan FIND di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/","og_site_name":"Statorials","article_published_time":"2023-07-04T16:10:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sfind0.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\/pencarian-excel-vs-temukan\/","url":"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/","name":"Excel: perbedaan fungsi SEARCH dan FIND - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T16:10:30+00:00","dateModified":"2023-07-04T16:10:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan perbedaan fungsi SEARCH dan FIND di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pencarian-excel-vs-temukan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: perbedaan antara fungsi search dan find"}]},{"@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\/5043"}],"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=5043"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5043\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5043"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5043"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}