{"id":3750,"date":"2023-07-15T18:42:25","date_gmt":"2023-07-15T18:42:25","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/"},"modified":"2023-07-15T18:42:25","modified_gmt":"2023-07-15T18:42:25","slug":"excel-arama-fonksiyonu-birden-fazla-deger","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/","title":{"rendered":"Excel: birden fazla de\u011fer bulmak i\u00e7in arama i\u015flevini kullan\u0131n"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Excel&#8217;deki <strong>ARAMA<\/strong> i\u015flevi, bir metin dizesinin di\u011ferinin i\u00e7indeki konumunu bulmak i\u00e7in kullan\u0131labilir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ancak bazen bir metin dizesinin varl\u0131\u011f\u0131n\u0131 di\u011ferindeki birden \u00e7ok metin dizesi aras\u0131nda bulmak i\u00e7in <strong>ARAMA<\/strong> i\u015flevini kullanmak isteyebilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--ISNUMBER(SEARCH({\"string1\",\"string2\",\"string3\"}, <span style=\"color: #3366ff;\">A2<\/span> )))&gt;0<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bu \u00f6zel form\u00fcl, <strong>A2<\/strong> h\u00fccresindeki dizede &#8220;dize1&#8221;, &#8220;dize2&#8221; ve &#8220;dize3&#8221; ifadesini arar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu dizelerden biri bulunursa form\u00fcl <strong>TRUE<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Aksi takdirde <strong>FALSE<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: Excel&#8217;de birden \u00e7ok de\u011feri aramak i\u00e7in ARAMA i\u015flevini kullan\u0131n<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel&#8217;de a\u015fa\u011f\u0131daki basketbol tak\u0131m\u0131 adlar\u0131 listesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30492 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu1.jpg\" alt=\"\" width=\"534\" height=\"486\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u015eimdi her sat\u0131rda tak\u0131m ad\u0131n\u0131n &#8220;Pacers&#8221;, &#8220;Raptors&#8221; veya &#8220;Nuggets&#8221; olup olmad\u0131\u011f\u0131n\u0131 belirlemek istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--ISNUMBER(SEARCH({\"Pacers\",\"Raptors\",\"Nuggets\"}, <span style=\"color: #3366ff;\">A2<\/span> )))&gt;0<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bu form\u00fcl\u00fc B2 h\u00fccresine yazabilir, ard\u0131ndan bu form\u00fcl\u00fc t\u0131klay\u0131p B s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30550 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherche1.jpg\" alt=\"\" width=\"599\" height=\"483\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Tak\u0131m ad\u0131 belirtti\u011fimiz \u00fc\u00e7 dizeden herhangi birini i\u00e7eriyorsa B S\u00fctunu <strong>TRUE de\u011ferini<\/strong> g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Aksi takdirde <strong>FALSE<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>DO\u011eRU<\/strong> ve <strong>YANLI\u015e<\/strong> yerine <strong>1<\/strong> veya <strong>0 de\u011ferini<\/strong> d\u00f6nd\u00fcrmek istiyorsan\u0131z a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(SUMPRODUCT(--ISNUMBER(SEARCH({\"Pacers\",\"Raptors\",\"Nuggets\"}, <span style=\"color: #3366ff;\">A2<\/span> )))&gt;0,1,0)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30551 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherche2.jpg\" alt=\"\" width=\"563\" height=\"479\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Tak\u0131m ad\u0131 belirtti\u011fimiz \u00fc\u00e7 dizeden birini i\u00e7eriyorsa B s\u00fctunu <b>1 de\u011ferini<\/b> g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Aksi takdirde <strong>0<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/excel-karaktere-kaldi\/\" target=\"_blank\" rel=\"noopener\">Excel: belirli bir karaktere kadar SOL i\u00e7in bir form\u00fcl<\/a><br \/><a href=\"https:\/\/statorials.org\/tr\/dizenin-sonunda-excel-mi-islevi\/\" target=\"_blank\" rel=\"noopener\">Excel: Dizeyi sonland\u0131rmak i\u00e7in MID i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-mi-islevi-degisken-uzunlugu\/\" target=\"_blank\" rel=\"noopener\">Excel: De\u011fi\u015fken Uzunluktaki Dizeler i\u00e7in MID \u0130\u015flevi Nas\u0131l Kullan\u0131l\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel&#8217;deki ARAMA i\u015flevi, bir metin dizesinin di\u011ferinin i\u00e7indeki konumunu bulmak i\u00e7in kullan\u0131labilir. Ancak bazen bir metin dizesinin varl\u0131\u011f\u0131n\u0131 di\u011ferindeki birden \u00e7ok metin dizesi aras\u0131nda bulmak i\u00e7in ARAMA i\u015flevini kullanmak isteyebilirsiniz. Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =SUMPRODUCT(&#8211;ISNUMBER(SEARCH({&#8220;string1&#8243;,&#8221;string2&#8243;,&#8221;string3&#8243;}, A2 )))&gt;0 Bu \u00f6zel form\u00fcl, A2 h\u00fccresindeki dizede &#8220;dize1&#8221;, &#8220;dize2&#8221; ve &#8220;dize3&#8221; ifadesini arar. Bu dizelerden biri bulunursa [&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":[],"class_list":["post-3750","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Birden fazla de\u011fer bulmak i\u00e7in ARAMA i\u015flevini kullan\u0131n - Statoryaller<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, bir \u00f6rnek de dahil olmak \u00fczere birden \u00e7ok de\u011feri bulmak i\u00e7in Excel&#039;deki ARAMA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Birden fazla de\u011fer bulmak i\u00e7in ARAMA i\u015flevini kullan\u0131n - Statoryaller\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, bir \u00f6rnek de dahil olmak \u00fczere birden \u00e7ok de\u011feri bulmak i\u00e7in Excel&#039;deki ARAMA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T18:42:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu1.jpg\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/\",\"name\":\"Excel: Birden fazla de\u011fer bulmak i\u00e7in ARAMA i\u015flevini kullan\u0131n - Statoryaller\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-15T18:42:25+00:00\",\"dateModified\":\"2023-07-15T18:42:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, bir \u00f6rnek de dahil olmak \u00fczere birden \u00e7ok de\u011feri bulmak i\u00e7in Excel&#39;deki ARAMA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: birden fazla de\u011fer bulmak i\u00e7in arama i\u015flevini kullan\u0131n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Birden fazla de\u011fer bulmak i\u00e7in ARAMA i\u015flevini kullan\u0131n - Statoryaller","description":"Bu e\u011fitimde, bir \u00f6rnek de dahil olmak \u00fczere birden \u00e7ok de\u011feri bulmak i\u00e7in Excel&#39;deki ARAMA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","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\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: Birden fazla de\u011fer bulmak i\u00e7in ARAMA i\u015flevini kullan\u0131n - Statoryaller","og_description":"Bu e\u011fitimde, bir \u00f6rnek de dahil olmak \u00fczere birden \u00e7ok de\u011feri bulmak i\u00e7in Excel&#39;deki ARAMA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/","og_site_name":"Statorials","article_published_time":"2023-07-15T18:42:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu1.jpg"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/","url":"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/","name":"Excel: Birden fazla de\u011fer bulmak i\u00e7in ARAMA i\u015flevini kullan\u0131n - Statoryaller","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-15T18:42:25+00:00","dateModified":"2023-07-15T18:42:25+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, bir \u00f6rnek de dahil olmak \u00fczere birden \u00e7ok de\u011feri bulmak i\u00e7in Excel&#39;deki ARAMA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-arama-fonksiyonu-birden-fazla-deger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: birden fazla de\u011fer bulmak i\u00e7in arama i\u015flevini kullan\u0131n"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3750","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=3750"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3750\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=3750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=3750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=3750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}