{"id":4103,"date":"2023-07-13T14:09:33","date_gmt":"2023-07-13T14:09:33","guid":{"rendered":"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/"},"modified":"2023-07-13T14:09:33","modified_gmt":"2023-07-13T14:09:33","slug":"tanda-bintang-pencarian-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/","title":{"rendered":"Cara menemukan tanda bintang di sel di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk memeriksa apakah sel tertentu di Excel berisi tanda bintang di mana pun di sel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(ISNUMBER(SEARCH(\"~*\", <span style=\"color: #3366ff;\">A2<\/span> )), \"Yes\", \"No\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini memeriksa apakah sel <strong>A2<\/strong> berisi tanda bintang dan mengembalikan &#8220;Ya&#8221; jika ada.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tidak, ia akan mengembalikan &#8220;Tidak&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Simbol tilde ( <strong>~<\/strong> ) di Excel menunjukkan bahwa karakter berikut adalah literal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Contoh: Temukan tanda bintang di sel di Excel<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32622 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ast1.png\" alt=\"\" width=\"493\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tanda bintang di akhir nama tim menunjukkan bahwa pemain tersebut adalah All-Star.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mencari nama masing-masing tim di kolom A untuk menentukan apakah setiap pemain adalah All-Star atau tidak.<\/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>=IF(ISNUMBER(SEARCH(\"~*\", <span style=\"color: #3366ff;\">A2<\/span> )), \"Yes\", \"No\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32623\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ast2.png\" alt=\"Excel menemukan tanda bintang di sel\" width=\"566\" height=\"459\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan &#8220;Ya&#8221; jika nama tim mengandung tanda bintang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tidak, ia akan mengembalikan &#8220;Tidak&#8221; jika tidak ada tanda bintang yang ditemukan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><b>Mavs*<\/b> berisi tanda bintang.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><b>Jaring<\/b> tidak mengandung tanda bintang.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><b>Warriors<\/b> tidak mengandung tanda bintang.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda ingin mengembalikan nilai selain &#8220;Ya&#8221; dan &#8220;Tidak&#8221;, cukup ganti nilai tersebut dalam rumus dengan nilai yang Anda inginkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa Anda bisa menggunakan rumus berikut untuk mengembalikan <strong>TRUE<\/strong> atau <strong>FALSE<\/strong> untuk menunjukkan apakah sel berisi tanda bintang atau tidak:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=ISNUMBER(SEARCH(\"~*\", <span style=\"color: #3366ff;\">A2<\/span> ))<\/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-32624 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ast3.png\" alt=\"\" width=\"493\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan <strong>TRUE<\/strong> atau <strong>FALSE<\/strong> untuk menunjukkan apakah setiap nama tim mengandung tanda bintang atau tidak.<\/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\/pernyataan-kasus-di-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menulis pernyataan kasus<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-nilai-unik-di-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menemukan nilai unik dari beberapa kolom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Mencocokkan Dua Kolom dan Mengembalikan Kolom Ketiga<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk memeriksa apakah sel tertentu di Excel berisi tanda bintang di mana pun di sel: =IF(ISNUMBER(SEARCH(&#8220;~*&#8221;, A2 )), &#8220;Yes&#8221;, &#8220;No&#8221;) Rumus khusus ini memeriksa apakah sel A2 berisi tanda bintang dan mengembalikan &#8220;Ya&#8221; jika ada. Jika tidak, ia akan mengembalikan &#8220;Tidak&#8221;. Catatan : Simbol tilde ( ~ ) di Excel [&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>Cara menemukan tanda bintang pada sel di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menemukan tanda bintang pada sel di Excel, beserta 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\/tanda-bintang-pencarian-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menemukan tanda bintang pada sel di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menemukan tanda bintang pada sel di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T14:09:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ast1.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\/tanda-bintang-pencarian-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/\",\"name\":\"Cara menemukan tanda bintang pada sel di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T14:09:33+00:00\",\"dateModified\":\"2023-07-13T14:09:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menemukan tanda bintang pada sel di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menemukan tanda bintang di sel di excel\"}]},{\"@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":"Cara menemukan tanda bintang pada sel di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menemukan tanda bintang pada sel di Excel, beserta 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\/tanda-bintang-pencarian-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menemukan tanda bintang pada sel di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menemukan tanda bintang pada sel di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-13T14:09:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ast1.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\/tanda-bintang-pencarian-excel\/","url":"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/","name":"Cara menemukan tanda bintang pada sel di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T14:09:33+00:00","dateModified":"2023-07-13T14:09:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menemukan tanda bintang pada sel di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tanda-bintang-pencarian-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menemukan tanda bintang di sel di excel"}]},{"@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\/4103"}],"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=4103"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4103\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}