{"id":1756,"date":"2023-11-06T22:52:07","date_gmt":"2023-11-06T22:52:07","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/"},"modified":"2023-12-10T05:58:30","modified_gmt":"2023-12-10T05:58:30","slug":"dokulme-hatasi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/","title":{"rendered":"#spread nas\u0131l d\u00fczeltilir? excel&#39;de hata m\u0131 var?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1594644627\"><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> <h2 id=\"h-spill-range-is-not-blank\" class=\"wp-block-heading\">D\u00f6k\u00fclme aral\u0131\u011f\u0131 bo\u015f de\u011fil<\/h2><p> Excel&#8217;de #D\u00d6K\u00dcNT\u00dc! Sonucu birka\u00e7 h\u00fccre aral\u0131\u011f\u0131nda d\u00f6nd\u00fcren dinamik bir i\u015flev kulland\u0131\u011f\u0131n\u0131zda hata olu\u015ftu, ancak bu aral\u0131k zaten de\u011ferler i\u00e7eriyor ve art\u0131k bu dinamik i\u015flev, bu aral\u0131ktaki sonucu d\u00f6nd\u00fcrmek i\u00e7in de\u011ferlerin \u00fczerine yazam\u0131yor. \u015eimdi sonucu almak i\u00e7in aral\u0131ktaki de\u011ferleri silmeniz gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72518\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-deversement.png\" sizes=\"auto, \" srcset=\"\" alt=\"de\u015farj aral\u0131\u011f\u0131\" width=\"462\" height=\"317\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte, tan\u0131mlad\u0131\u011f\u0131n\u0131z belirli bir h\u00fccre aral\u0131\u011f\u0131nda rastgele de\u011ferler d\u00f6nd\u00fcren RANDARRAY fonksiyonunu kulland\u0131\u011f\u0131m\u0131z\u0131 g\u00f6rebilirsiniz. Ve fonksiyonda A1:E5 aral\u0131\u011f\u0131ndaki sonu\u00e7 de\u011ferleri i\u00e7in be\u015f sat\u0131r ve be\u015f s\u00fctun tan\u0131ml\u0131yorum.<\/p><p> \u015eimdi, B3 h\u00fccresinde g\u00f6rebilece\u011finiz gibi, orada zaten bir de\u011ferim var ve bu dinamik form\u00fcl\u00fcn sonucunu geni\u015fletememesinin ve #D\u00d6K\u00dcNME! sonucunu d\u00f6nd\u00fcrmesinin nedeni budur! Hata. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72519\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-valeur-dans-la-plage-de-deversement.png\" sizes=\"auto, \" srcset=\"\" alt=\"d\u00f6k\u00fclme de\u011feri aral\u0131\u011f\u0131\" width=\"395\" height=\"414\"><\/figure><\/div><p> Bu sorunu \u00e7\u00f6zmek i\u00e7in, B3 h\u00fccresindeki de\u011feri kald\u0131rman\u0131z gerekir; dinamik i\u015flev (RANDARRAY) geni\u015fler ve be\u015f sat\u0131r ve be\u015f s\u00fctundan olu\u015fan A1:E5 aral\u0131\u011f\u0131ndaki sonucu d\u00f6nd\u00fcr\u00fcr.<\/p><h2 id=\"h-spill-range-error-in-a-table\" class=\"wp-block-heading\"> Bir dizide d\u00f6k\u00fclme aral\u0131\u011f\u0131 hatas\u0131<\/h2><p> Dinamik diziler kullan\u0131yorsan\u0131z, bu durumda #D\u00d6K\u00dcLME! hatas\u0131yla kar\u015f\u0131la\u015fma ihtimaliniz vard\u0131r. hata. Bunun nedeni <strong><mark class=\"has-inline-color\" style=\"background-color: #fdde6c;\">tablolar\u0131n hen\u00fcz dinamik form\u00fclleri desteklememesidir<\/mark><\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72520\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-erreur-de-plage-de-deversement-dans-le-tableau.png\" sizes=\"auto, \" srcset=\"\" alt=\"tablodaki d\u00f6k\u00fclme aral\u0131\u011f\u0131 hatas\u0131\" width=\"501\" height=\"466\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte, bir s\u00fctun ve on sat\u0131rda rastgele say\u0131y\u0131 almaya \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131z Tablo1&#8217;e sahibiz, ancak tabloyu kullan\u0131rken ta\u015fma hatas\u0131 d\u00f6nd\u00fcrd\u00fc.<\/p><p> Microsoft&#8217;a g\u00f6re Excel tablolar\u0131nda dinamik i\u015flevler i\u00e7in hen\u00fcz bir destek bulunmuyor. \u00c7\u00f6z\u00fcm, tabloyu normal aral\u0131\u011fa d\u00f6n\u00fc\u015ft\u00fcrmek veya form\u00fcl\u00fcn\u00fcz\u00fc normal aral\u0131\u011fa ta\u015f\u0131makt\u0131r.<\/p><p class=\"myalert\"> Ve tablonuzu normal aral\u0131\u011fa d\u00f6n\u00fc\u015ft\u00fcrd\u00fc\u011f\u00fcn\u00fczde form\u00fcl\u00fc silip tekrar girdi\u011finizden emin olun, aksi takdirde son de\u011fer d\u0131\u015f\u0131ndaki t\u00fcm de\u011ferler i\u00e7in size her zaman hatay\u0131 g\u00f6sterecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72521\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-supprimer-et-saisir-a-nouveau-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"form\u00fcl\u00fc silip yeniden girin\" width=\"387\" height=\"550\"><\/figure><\/div><p> Tabloyu normal bir aral\u0131\u011fa d\u00f6n\u00fc\u015ft\u00fcrd\u00fc\u011f\u00fcn\u00fczde Excel, dinamik form\u00fcl\u00fc di\u011fer h\u00fccrelere geni\u015fletmeye \u00e7al\u0131\u015f\u0131r, ancak bu h\u00fccrelerde h\u00e2l\u00e2 yay\u0131lma hatas\u0131 vard\u0131r (form\u00fcl i\u00e7eren son h\u00fccre d\u0131\u015f\u0131nda) ve bu nedenle dinamik form\u00fcl, sonucu sizin i\u00e7in al\u0131n.<\/p><h2 id=\"h-spill-error-problem-with-vlookup\" class=\"wp-block-heading\"> #YAYILMAK! D\u00dc\u015eEYARA ile ilgili hata sorunu<\/h2><p> D\u00dc\u015eEYARA ile d\u00f6k\u00fclme hatas\u0131yla kar\u015f\u0131la\u015fabilirsiniz. <a href=\"https:\/\/exceladvisor.org\/tr\/iferror-gorunumu\/\">D\u00dc\u015eEYARA ile bu hatay\u0131<\/a> almak yayg\u0131n de\u011fildir, ancak bu hatay\u0131 alma \u015fans\u0131 vard\u0131r. Bunu anlamak i\u00e7in durumu ve form\u00fcl\u00fc nas\u0131l yanl\u0131\u015f kulland\u0131\u011f\u0131n\u0131z\u0131 anlaman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72522\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-erreur-de-deversement-avec-vlookup.png\" sizes=\"auto, \" srcset=\"\" alt=\"vlookup ile d\u00f6k\u00fclme hatas\u0131\" width=\"410\" height=\"395\"><\/figure><\/div><p> Yukar\u0131daki form\u00fclde arama de\u011ferinde tek bir h\u00fccreye at\u0131fta bulunmak yerine t\u00fcm s\u00fctuna at\u0131fta bulunarak onu dinamik bir form\u00fcl haline getirdim.<\/p><p> \u015eimdi toplam 1048576 h\u00fccreye sahip oldu\u011fum s\u00fctunun tamam\u0131na de\u011findi\u011fimde, dinamik form\u00fclle Excel 1048576 sonu\u00e7 d\u00f6nd\u00fcrecektir. Do\u011fru?<\/p><p><mark class=\"has-inline-color\" style=\"background-color: #fdde6c;\"> <strong>\u015eimdi sorun \u015fu ki<\/strong><\/mark> 1048576 sonucunu elde etmek i\u00e7in 1048576 h\u00fccreye ihtiyac\u0131m var, ancak form\u00fcl\u00fcm D2&#8217;den ba\u015flad\u0131\u011f\u0131 i\u00e7in bir h\u00fccreyi \u00f6zl\u00fcyorum. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72523\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-formule-de-recherche-v.png\" sizes=\"auto, \" srcset=\"\" alt=\"vlookup form\u00fcl\u00fc\" width=\"447\" height=\"414\"><\/figure><\/div><p> Ve ayn\u0131 form\u00fcl\u00fc bir s\u00fctunun ilk h\u00fccresinden kulland\u0131\u011f\u0131mda t\u00fcm form\u00fclleri do\u011fru bir \u015fekilde elde ediyorum.<\/p><h2 id=\"h-merge-cell-can-also-cause-a-spill-error\" class=\"wp-block-heading\"> H\u00fccrelerin birle\u015ftirilmesi ayn\u0131 zamanda #D\u00d6K\u00dcLME&#8217;ye de neden olabilir! Hata<\/h2><p> Dinamik form\u00fcl girerken d\u00f6k\u00fclme aral\u0131\u011f\u0131nda birle\u015ftirilmi\u015f h\u00fccre varsa bu durumda da sonu\u00e7ta d\u00f6k\u00fclme hatas\u0131 al\u0131rs\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72524\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-cellule-de-fusion-provoque-une-erreur-de-debordement.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccre birle\u015ftirme-d\u00f6k\u00fclme-hatas\u0131na neden olur\" width=\"465\" height=\"357\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte B2:C3 aral\u0131\u011f\u0131 i\u00e7in birle\u015ftirilmi\u015f bir h\u00fccremiz var ve A1 h\u00fccresine RASTGELE girmeyi denedi\u011fimizde, birle\u015ftirilmi\u015f bir h\u00fccrede sonucu yeniden yazamad\u0131\u011f\u0131 i\u00e7in A1 h\u00fccresinde ta\u015fma hatas\u0131 veriyor.<\/p><h2 id=\"h-selecting-obstructing-cells-to-fix-the-spill-error\" class=\"wp-block-heading\"> #D\u00d6K\u00dcLM\u00dc onarmak i\u00e7in engelleyici h\u00fccrelerin se\u00e7imi! Hata<\/h2><p> #D\u00d6K\u00dcM!&#8217;\u00fcn bulundu\u011fu h\u00fccreye t\u0131klad\u0131\u011f\u0131n\u0131zda! hata, bununla ba\u015fa \u00e7\u0131kmak i\u00e7in baz\u0131 se\u00e7eneklerin bulundu\u011fu bir a\u00e7\u0131l\u0131r men\u00fc sunar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72525\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-cellules-obstruantes-selectionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"engelleyici h\u00fccreleri se\u00e7\" width=\"389\" height=\"377\"><\/figure><\/div><p> \u00dc\u00e7\u00fcnc\u00fc konumda, engelleyici h\u00fccreleri, yani sonucu engelleyen h\u00fccreleri se\u00e7me se\u00e7ene\u011fini g\u00f6r\u00fcnt\u00fcler. Ve bu se\u00e7ene\u011fe t\u0131klad\u0131\u011f\u0131n\u0131z anda de\u011feri olan t\u00fcm h\u00fccreler se\u00e7ilecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72526\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-cellules-ont-deja-une-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccre-zaten-de\u011ferler\" width=\"429\" height=\"212\"><\/figure><\/div><p> Birden fazla h\u00fccreniz varsa, t\u00fcm bu h\u00fccreleri se\u00e7ecektir ve bu h\u00fccrelerdeki de\u011ferleri kald\u0131rarak, form\u00fclde tan\u0131mlanan aral\u0131kta sonu\u00e7 elde edebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72527\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-cellules-multiples-ayant-une-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir de\u011fere sahip birka\u00e7 h\u00fccre\" width=\"476\" height=\"204\"><\/figure><\/div><h2 id=\"h-use-for-implicit-intersection\" class=\"wp-block-heading\"> \u00d6rt\u00fcl\u00fc kesi\u015fim i\u00e7in @ kullan\u0131n<\/h2><p> Ta\u015fma aral\u0131\u011f\u0131 kullanan dinamik bir i\u015flev kullan\u0131rken (sonu\u00e7 birden \u00e7ok h\u00fccrede d\u00f6nd\u00fcr\u00fcl\u00fcr), #D\u00d6K\u00dcLMEY\u0130 \u00f6nlemek i\u00e7in! hatas\u0131 al\u0131rsan\u0131z, form\u00fcl\u00fcn sonu\u00e7lar\u0131 birden fazla h\u00fccreye y\u00f6nelik bir dizi yerine tek bir h\u00fccreye d\u00f6nd\u00fcrmesini sa\u011flamak i\u00e7in form\u00fcl\u00fcn ba\u015f\u0131ndaki @ operat\u00f6r\u00fcn\u00fc kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72528\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-utilisation-pour-intersection-implicite.png\" sizes=\"auto, \" srcset=\"\" alt=\"z\u0131mni-kav\u015fak i\u00e7in-@-kullan\" width=\"497\" height=\"328\"><\/figure><\/div><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\/11\/erreur-de-deversement-2.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\/bolme-hatasi\/\">Hata #DIV\/0<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/\">#VALUE Hata<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hatalari-gormezden-gel\/\">Excel&#8217;deki t\u00fcm hatalar\u0131 yoksay<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hata-yok\/\">#YOK Excel&#8217;de Hata<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/\">#REF! Excel&#8217;de hata<\/a><\/li><\/ul><\/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-1756","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>#SPREAD nas\u0131l d\u00fczeltilir? Excel&#039;de hata m\u0131 var? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"#D\u00d6K\u00dcLME alman\u0131z\u0131n bir\u00e7ok nedeni var! Dinamik bir fonksiyonun sonucundaki hata ve bu derste biz\" \/>\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\/dokulme-hatasi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"#SPREAD nas\u0131l d\u00fczeltilir? Excel&#039;de hata m\u0131 var? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"#D\u00d6K\u00dcLME alman\u0131z\u0131n bir\u00e7ok nedeni var! Dinamik bir fonksiyonun sonucundaki hata ve bu derste biz\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:58:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-deversement.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=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/\",\"name\":\"#SPREAD nas\u0131l d\u00fczeltilir? Excel&#39;de hata m\u0131 var? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-deversement.png\",\"datePublished\":\"2023-11-06T22:52:07+00:00\",\"dateModified\":\"2023-12-10T05:58:30+00:00\",\"description\":\"#D\u00d6K\u00dcLME alman\u0131z\u0131n bir\u00e7ok nedeni var! Dinamik bir fonksiyonun sonucundaki hata ve bu derste biz\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-deversement.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-deversement.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"#spread nas\u0131l d\u00fczeltilir? excel&#39;de hata m\u0131 var?\"}]},{\"@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":"#SPREAD nas\u0131l d\u00fczeltilir? Excel&#39;de hata m\u0131 var? (E\u011fitim 2023)","description":"#D\u00d6K\u00dcLME alman\u0131z\u0131n bir\u00e7ok nedeni var! Dinamik bir fonksiyonun sonucundaki hata ve bu derste biz","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\/dokulme-hatasi\/","og_locale":"tr_TR","og_type":"article","og_title":"#SPREAD nas\u0131l d\u00fczeltilir? Excel&#39;de hata m\u0131 var? (E\u011fitim 2023)","og_description":"#D\u00d6K\u00dcLME alman\u0131z\u0131n bir\u00e7ok nedeni var! Dinamik bir fonksiyonun sonucundaki hata ve bu derste biz","og_url":"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:58:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-deversement.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/","url":"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/","name":"#SPREAD nas\u0131l d\u00fczeltilir? Excel&#39;de hata m\u0131 var? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-deversement.png","datePublished":"2023-11-06T22:52:07+00:00","dateModified":"2023-12-10T05:58:30+00:00","description":"#D\u00d6K\u00dcLME alman\u0131z\u0131n bir\u00e7ok nedeni var! Dinamik bir fonksiyonun sonucundaki hata ve bu derste biz","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-deversement.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-deversement.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"#spread nas\u0131l d\u00fczeltilir? excel&#39;de hata m\u0131 var?"}]},{"@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\/1756","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=1756"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1756\/revisions"}],"predecessor-version":[{"id":2250,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1756\/revisions\/2250"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}