{"id":1785,"date":"2023-11-05T01:44:39","date_gmt":"2023-11-05T01:44:39","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/"},"modified":"2023-12-10T05:58:46","modified_gmt":"2023-12-10T05:58:46","slug":"bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/","title":{"rendered":"Bir aral\u0131kta bir de\u011ferin olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2279774039\"><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>Excel&#8217;de, bir de\u011ferin bir aral\u0131kta olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in E\u011eER i\u015fleviyle birlikte E\u011eERSAY i\u015flevini kullanabilirsiniz. COUNTIF ile de\u011feri kontrol edebilir ve IF ile kullan\u0131c\u0131ya g\u00f6sterilecek bir sonu\u00e7 de\u011feri d\u00f6nd\u00fcrebilirsiniz. yani evet ya da hay\u0131r, bulundu ya da bulunamad\u0131.<\/p><h2 id=\"h-check-for-a-value-in-a-range\" class=\"wp-block-heading\"> Aral\u0131ktaki bir de\u011feri bulun<\/h2><p> A\u015fa\u011f\u0131daki \u00f6rnekte, yaln\u0131zca adlar\u0131n\u0131z\u0131n bulundu\u011fu bir ad listeniz var ve \u015fimdi &#8220;GLEN&#8221;in orada olup olmad\u0131\u011f\u0131n\u0131 kontrol etmeniz gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67089\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms.png\" sizes=\"auto, \" srcset=\"\" alt=\"isim listesi\" width=\"268\" height=\"296\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullanabilirsiniz:<\/p><ol><li> \u00d6ncelikle B1 h\u00fccresine E\u011eER fonksiyonunu girmeniz gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-i\u015flev-e\u011fer-girin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-entrez-la-fonction-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-the-if-function\" width=\"538\" height=\"173\"><\/li><li> Bundan sonra, ilk arg\u00fcmanda (mant\u0131ksal test), oraya COUNTIF fonksiyonunu girmeniz gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-e\u011fer-hesap-i\u015flevini girin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrer-le-decompte-si-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-the-count-if-function\" width=\"481\" height=\"177\"><\/li><li> \u015eimdi E\u011eERSAY i\u015flevinde A1:A10 aral\u0131\u011f\u0131na bak\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-bir aral\u0131\u011fa-ba\u015fvuru\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-font-reference-a-une-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"refer-to-a-range\" width=\"533\" height=\"172\"><\/li><li> Daha sonra \u00f6l\u00e7\u00fct ba\u011f\u0131ms\u0131z de\u011fi\u015fkenine &#8220;Glen&#8221; yaz\u0131n ve E\u011eERSAY i\u015flevine ili\u015fkin parantezleri kapat\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-iddialar\u0131 kapat\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-fermer-les-parentheses.png\" sizes=\"auto, \" srcset=\"\" alt=\"close-the-prentheses\" width=\"534\" height=\"190\"><\/li><li> Ayr\u0131ca b\u00fcy\u00fckt\u00fcr i\u015fareti kullan\u0131n ve s\u0131f\u0131r girin. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-b\u00fcy\u00fckt\u00fcr i\u015faretini kullan\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-utiliser-le-signe-superieur-a.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-greater-than-sign\" width=\"559\" height=\"192\"><\/li><li> Buradan, IF&#8217;deki bir sonraki arg\u00fcmana ge\u00e7mek i\u00e7in bir komut girin ve ikinci arg\u00fcmana &#8220;Evet&#8221; yaz\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-e\u011fer-sonraki-arg\u00fcman\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-argument-suivant-dans-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"next-argument-in-if\" width=\"638\" height=\"177\"><\/li><li> Sonunda bir virg\u00fcl girin ve \u00fc\u00e7\u00fcnc\u00fc ba\u011f\u0131ms\u0131z de\u011fi\u015fkene &#8220;Hay\u0131r&#8221; yaz\u0131n ve kapan\u0131\u015f parantezlerini yaz\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"8-tip-kapan\u0131\u015f-\u015fakalar\u0131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-tapez-les-parentheses-finales.png\" sizes=\"auto, \" srcset=\"\" alt=\"type-the-closing-prantheses\" width=\"635\" height=\"188\"><\/li><\/ol><p> Enter tu\u015funa bast\u0131\u011f\u0131n\u0131z anda &#8220;Evet&#8221; de\u011feri \u00e7\u0131k\u0131yor \u00e7\u00fcnk\u00fc arad\u0131\u011f\u0131n\u0131z aral\u0131ktaki de\u011fere sahipsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67097\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-renvoie-la-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"geri d\u00f6n\u00fc\u015f de\u011feri\" width=\"530\" height=\"311\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(COUNTIF(A1:A10,\"Glen\")&gt;0,\"Yes\",\"No\")<\/code><\/pre><p> <em>Daha fazlas\u0131n\u0131 \u00f6\u011frenmek ister misiniz? \u015eu \u00fccretsiz kurslara g\u00f6z at\u0131n: Meslekta\u015flar\u0131n\u0131zdan daha ak\u0131ll\u0131 olman\u0131z\u0131 sa\u011flayacak 50 Excel form\u00fcl\u00fc<\/em><\/p><h2 id=\"h-how-this-formula-works\" class=\"wp-block-heading\"> Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h2><p> Bu form\u00fcl\u00fcn iki k\u0131sm\u0131 vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67098\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-si-countif-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"if-countif-form\u00fcl\u00fc\" width=\"583\" height=\"128\"><\/figure><\/div><p> \u0130lk b\u00f6l\u00fcmde, de\u011ferin aral\u0131kta olu\u015fumunu sayan COUNTIF&#8217;imiz var. \u0130kinci k\u0131s\u0131mda ise COUNTIF fonksiyonunun de\u011ferlerini alan IF fonksiyonunuz var.<\/p><p> Dolay\u0131s\u0131yla, E\u011eERSAY, de\u011ferin aral\u0131kta oldu\u011fu anlam\u0131na gelenden daha b\u00fcy\u00fck bir de\u011fer d\u00f6nd\u00fcr\u00fcrse IF, Evet de\u011ferini d\u00f6nd\u00fcr\u00fcr. COUNTIF 0 de\u011ferini d\u00f6nd\u00fcr\u00fcrse bu, de\u011ferin aral\u0131kta olmad\u0131\u011f\u0131 ve Hay\u0131r de\u011ferini d\u00f6nd\u00fcrd\u00fc\u011f\u00fc anlam\u0131na gelir.<\/p><h2 id=\"h-check-for-a-value-in-a-range-partially\" class=\"wp-block-heading\"> Bir aral\u0131ktaki de\u011feri k\u0131smen aray\u0131n<\/h2><p> Bir aral\u0131\u011f\u0131n k\u0131smi de\u011ferini kontrol etmek istedi\u011finiz bir durum vard\u0131r. Bu durumda joker karakterler (y\u0131ld\u0131z i\u015fareti *) kullanman\u0131z gerekir.<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte ayn\u0131 ad listesine sahibiz ancak burada tam ad\u0131 bulabilirsiniz. Ama yine de &#8220;Glen&#8221; ismine bakmam\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67099\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-verifier-la-valeur-dans-la-plage-partiellement.png\" sizes=\"auto, \" srcset=\"\" alt=\"aral\u0131ktaki de\u011feri k\u0131smen kontrol et\" width=\"407\" height=\"341\"><\/figure><\/div><p> Aramak istedi\u011finiz de\u011fer, yukar\u0131daki \u00f6rnekte kulland\u0131\u011f\u0131m\u0131z y\u0131ld\u0131z i\u015faretiyle \u00e7evrelenmelidir. Bu, Excel&#8217;e, de\u011ferden \u00f6nce ve sonra ne oldu\u011funa bak\u0131lmaks\u0131z\u0131n &#8220;Glen&#8221; de\u011ferini kontrol etmesini s\u00f6yler.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(COUNTIF(C1:C10,\"*\"&amp;\"Glen\"&amp;\"*\")&gt;0,\"Yes\",\"No\")<\/code><\/pre><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-verifier-si-la-valeur-existe-dans-une-plage.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sifirsa-o-zaman-bos\/\">IF 0 (s\u0131f\u0131r) de\u011ferini kontrol edin ve ard\u0131ndan Excel&#8217;de bo\u015f b\u0131rak\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-ve-1\/\">Excel&#8217;de E\u011eER ve VE i\u015flevlerini birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-veya-1\/\">Excel&#8217;de IF ve OR i\u015flevlerini birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucre-bossa\/\">IF H\u00fccresi Excel&#8217;de IF + ISBLANK kullan\u0131larak bo\u015f (bo\u015f)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/negatifse-sifir\/\">Negatifse Excel&#8217;de s\u0131f\u0131r (0)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1785","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>\u25b7 Bir de\u011ferin aral\u0131kta olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, iki y\u00f6ntemi kullanarak Excel&#039;de bir aral\u0131kta bir de\u011ferin olup olmad\u0131\u011f\u0131n\u0131 kontrol etmenin farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\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\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bir de\u011ferin aral\u0131kta olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, iki y\u00f6ntemi kullanarak Excel&#039;de bir aral\u0131kta bir de\u011ferin olup olmad\u0131\u011f\u0131n\u0131 kontrol etmenin farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:58:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/\",\"name\":\"\u25b7 Bir de\u011ferin aral\u0131kta olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms.png\",\"datePublished\":\"2023-11-05T01:44:39+00:00\",\"dateModified\":\"2023-12-10T05:58:46+00:00\",\"description\":\"Bu e\u011fitimde, iki y\u00f6ntemi kullanarak Excel&#39;de bir aral\u0131kta bir de\u011ferin olup olmad\u0131\u011f\u0131n\u0131 kontrol etmenin farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bir aral\u0131kta bir de\u011ferin olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bir de\u011ferin aral\u0131kta olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?","description":"Bu e\u011fitimde, iki y\u00f6ntemi kullanarak Excel&#39;de bir aral\u0131kta bir de\u011ferin olup olmad\u0131\u011f\u0131n\u0131 kontrol etmenin farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.","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\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Bir de\u011ferin aral\u0131kta olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?","og_description":"Bu e\u011fitimde, iki y\u00f6ntemi kullanarak Excel&#39;de bir aral\u0131kta bir de\u011ferin olup olmad\u0131\u011f\u0131n\u0131 kontrol etmenin farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:58:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/","url":"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/","name":"\u25b7 Bir de\u011ferin aral\u0131kta olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms.png","datePublished":"2023-11-05T01:44:39+00:00","dateModified":"2023-12-10T05:58:46+00:00","description":"Bu e\u011fitimde, iki y\u00f6ntemi kullanarak Excel&#39;de bir aral\u0131kta bir de\u011ferin olup olmad\u0131\u011f\u0131n\u0131 kontrol etmenin farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/bir-aralikta-bir-degerin-olup-olmadigini-kontrol-edin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Bir aral\u0131kta bir de\u011ferin olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1785"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1785\/revisions"}],"predecessor-version":[{"id":2269,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1785\/revisions\/2269"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}