{"id":4931,"date":"2023-07-06T07:19:19","date_gmt":"2023-07-06T07:19:19","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/"},"modified":"2023-07-06T07:19:19","modified_gmt":"2023-07-06T07:19:19","slug":"excel-metne-deger-atama","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/","title":{"rendered":"Excel: metne say\u0131sal de\u011fer nas\u0131l atan\u0131r"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">\u00c7o\u011fu zaman Excel&#8217;deki belirli metin de\u011ferlerine say\u0131sal bir de\u011fer atamak isteyebilirsiniz.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin, bir \u015firket i\u00e7indeki farkl\u0131 ma\u011fazalarda \u00e7al\u0131\u015fanlar\u0131n yapt\u0131\u011f\u0131 sat\u0131\u015flara ili\u015fkin bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011funuzu ve belirli ma\u011fazalara dayal\u0131 say\u0131sal de\u011ferler atamak istedi\u011finizi varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38477 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numtext1.png\" alt=\"\" width=\"498\" height=\"399\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bunu yapman\u0131n en kolay yolu, Excel&#8217;deki <strong>SWITCH<\/strong> i\u015flevini kullanmakt\u0131r; bu, bir listedeki e\u015fle\u015fen de\u011ferlerle e\u015fle\u015fen belirli de\u011ferleri d\u00f6nd\u00fcrmenize olanak tan\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnekte bu fonksiyonun pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: Excel&#8217;deki metne say\u0131sal de\u011ferler nas\u0131l atan\u0131r?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Belirli ma\u011fazalara a\u015fa\u011f\u0131daki say\u0131sal de\u011ferleri atamak istedi\u011finizi varsayal\u0131m:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Kuzey: 1001<\/span><\/li>\n<li> <span style=\"color: #000000;\">Do\u011fu: 1002<\/span><\/li>\n<li> <span style=\"color: #000000;\">G\u00fcney: 1003<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bat\u0131: 1004<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in <strong>D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SWITCH( <span style=\"color: #3366ff;\">B2<\/span> , \"North\", 1001, \"East\", 1002, \"South\", 1003, \"West\", 1004)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p D s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebilirsiniz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38478\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numtext2.png\" alt=\"Excel metne say\u0131sal bir de\u011fer atar\" width=\"668\" height=\"393\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Yeni <strong>Ma\u011faza Kimli\u011fi<\/strong> s\u00fctunu art\u0131k <strong>Ma\u011faza<\/strong> s\u00fctunundaki belirli metin de\u011feriyle e\u015fle\u015fen say\u0131sal bir de\u011fer i\u00e7eriyor.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Metin de\u011ferlerine say\u0131sal de\u011ferler atamak i\u00e7in kulland\u0131\u011f\u0131m\u0131z form\u00fcl\u00fc hat\u0131rlay\u0131n:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SWITCH( <span style=\"color: #3366ff;\">B2<\/span> , \"North\", 1001, \"East\", 1002, \"South\", 1003, \"West\", 1004)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bu form\u00fcl, a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanan <strong>ANAHTAR<\/strong> i\u015flevini kullan\u0131r:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>SWITCH(value to switch, find1, return1, find2, return2, ...)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">\u00d6zel form\u00fcl\u00fcm\u00fczde <strong>B2<\/strong> h\u00fccresini analiz ediyoruz ve a\u015fa\u011f\u0131dakileri yap\u0131yoruz:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">\u201cKuzey\u201di aray\u0131n \u2013 bulursan\u0131z <strong>1001&#8217;i<\/strong> d\u00f6nd\u00fcr\u00fcn<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bulunmazsa \u201cDo\u011fu\u201dyu aray\u0131n; bulunursa <strong>1002<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcn<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bulunmazsa \u201cG\u00fcney\u201di aray\u0131n; bulunursa <strong>1003<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcn<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bulunmazsa &#8220;Bat\u0131&#8221;y\u0131 aray\u0131n; bulunursa <strong>1004&#8217;\u00fc<\/strong> d\u00f6nd\u00fcr\u00fcn<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Bu mant\u0131\u011f\u0131 kullanarak her belirli metin de\u011ferine say\u0131sal de\u011ferler atayabiliriz.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Not<\/strong> : Excel&#8217;deki <strong>SWITCH<\/strong> i\u015flevinin tam belgelerini <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/switch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e\" target=\"_blank\" rel=\"noopener\">burada<\/a> bulabilirsiniz.<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/tr\/excel-sutundaki-degerin-ilk-olusumunu-bulma\/\" target=\"_blank\" rel=\"noopener\">Excel: Bir s\u00fctunda bir de\u011ferin ilk olu\u015fumunu bulun<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-sundan-buyuk-ilk-degeri-bul\/\" target=\"_blank\" rel=\"noopener\">Excel: Belirli bir say\u0131dan b\u00fcy\u00fck ilk de\u011feri bulun<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-satirdaki-sifir-olmayan-ilk-degeri-bulma\/\" target=\"_blank\" rel=\"noopener\">Excel: Bir sat\u0131rdaki s\u0131f\u0131r olmayan ilk de\u011fer nas\u0131l bulunur?<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00c7o\u011fu zaman Excel&#8217;deki belirli metin de\u011ferlerine say\u0131sal bir de\u011fer atamak isteyebilirsiniz. \u00d6rne\u011fin, bir \u015firket i\u00e7indeki farkl\u0131 ma\u011fazalarda \u00e7al\u0131\u015fanlar\u0131n yapt\u0131\u011f\u0131 sat\u0131\u015flara ili\u015fkin bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011funuzu ve belirli ma\u011fazalara dayal\u0131 say\u0131sal de\u011ferler atamak istedi\u011finizi varsayal\u0131m: Bunu yapman\u0131n en kolay yolu, Excel&#8217;deki SWITCH i\u015flevini kullanmakt\u0131r; bu, bir listedeki e\u015fle\u015fen de\u011ferlerle e\u015fle\u015fen belirli de\u011ferleri d\u00f6nd\u00fcrmenize [&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-4931","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: Metne say\u0131sal de\u011fer nas\u0131l atan\u0131r - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel&#039;deki metne nas\u0131l say\u0131sal bir de\u011fer atanaca\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-metne-deger-atama\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Metne say\u0131sal de\u011fer nas\u0131l atan\u0131r - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel&#039;deki metne nas\u0131l say\u0131sal bir de\u011fer atanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T07:19:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numtext1.png\" \/>\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-metne-deger-atama\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/\",\"name\":\"Excel: Metne say\u0131sal de\u011fer nas\u0131l atan\u0131r - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-06T07:19:19+00:00\",\"dateModified\":\"2023-07-06T07:19:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel&#39;deki metne nas\u0131l say\u0131sal bir de\u011fer atanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: metne say\u0131sal de\u011fer nas\u0131l atan\u0131r\"}]},{\"@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: Metne say\u0131sal de\u011fer nas\u0131l atan\u0131r - Statorials","description":"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel&#39;deki metne nas\u0131l say\u0131sal bir de\u011fer atanaca\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-metne-deger-atama\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: Metne say\u0131sal de\u011fer nas\u0131l atan\u0131r - Statorials","og_description":"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel&#39;deki metne nas\u0131l say\u0131sal bir de\u011fer atanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/","og_site_name":"Statorials","article_published_time":"2023-07-06T07:19:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numtext1.png"}],"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-metne-deger-atama\/","url":"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/","name":"Excel: Metne say\u0131sal de\u011fer nas\u0131l atan\u0131r - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-06T07:19:19+00:00","dateModified":"2023-07-06T07:19:19+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, eksiksiz bir \u00f6rnekle Excel&#39;deki metne nas\u0131l say\u0131sal bir de\u011fer atanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-metne-deger-atama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: metne say\u0131sal de\u011fer nas\u0131l atan\u0131r"}]},{"@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\/4931","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=4931"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4931\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}