{"id":2173,"date":"2023-09-26T05:13:14","date_gmt":"2023-09-26T05:13:14","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/"},"modified":"2023-12-10T05:58:30","modified_gmt":"2023-12-10T05:58:30","slug":"referans-hatasi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/","title":{"rendered":"#ref nas\u0131l d\u00fczeltilir? excel&#39;de hata m\u0131 var?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1364278595\"><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>\u00c7o\u011fu zaman #REF! Bir h\u00fccreye form\u00fcl girdi\u011finizde ve bu form\u00fcldeki ba\u015fvuru ge\u00e7ersiz oldu\u011funda hata olu\u015fur. Yani \u00f6rne\u011fin yukar\u0131daki be\u015f h\u00fccrenin de\u011ferlerini toplayan bir form\u00fcl\u00fcn\u00fcz oldu\u011funu varsayal\u0131m ve bu form\u00fcl\u00fc kopyalay\u0131p yukar\u0131da yaln\u0131zca \u00fc\u00e7 h\u00fccrenizin bulundu\u011fu bir konuma yap\u0131\u015ft\u0131r\u0131n; #REF alacaks\u0131n\u0131z! Hata.<\/p><h2 id=\"h-copied-formula-to-a-new-location\" class=\"wp-block-heading\"> Form\u00fcl yeni konuma kopyaland\u0131<\/h2><p> A\u015fa\u011f\u0131daki \u00f6rnekte A5 h\u00fccresinde A1:A5 aral\u0131\u011f\u0131ndaki de\u011ferleri toplayan toplam form\u00fcl\u00fcm\u00fcz var. Form\u00fclde g\u00f6receli bir h\u00fccre referans\u0131n\u0131z var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82504\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-reference-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel'de ba\u015fvuru hatas\u0131\" width=\"378\" height=\"382\"><\/figure><\/div><p> Bu form\u00fcl\u00fc kopyalay\u0131p C3 h\u00fccresine yap\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda #REF! Sonu\u00e7ta. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82505\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-renvoie-lerreur-de-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"d\u00f6n\u00fc\u015f-ref-hata\" width=\"496\" height=\"377\"><\/figure><\/div><p> Daha \u00f6nce de s\u00f6yledi\u011fim gibi, A6&#8217;dan C3&#8217;e form\u00fcl\u00fc kopyalad\u0131\u011f\u0131n\u0131zda, C3&#8217;\u00fcn \u00fcst\u00fcnde be\u015f h\u00fccre kalm\u0131yor, yani yukar\u0131dan be\u015f h\u00fccreye at\u0131fta bulunmak imkans\u0131z.<\/p><h2 id=\"h-ref-error-with-vlookup\" class=\"wp-block-heading\"> #REF! D\u00dc\u015eEYARA ile ilgili hata<\/h2><p> D\u00dc\u015eEYARA&#8217;y\u0131 kullan\u0131rken, de\u011feri almak istedi\u011finiz s\u00fctunu belirtin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82506\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-erreur-de-reference-avec-la-recherche-v.png\" sizes=\"auto, \" srcset=\"\" alt=\"vlookup ile ref hatas\u0131\" width=\"601\" height=\"317\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte form\u00fclde \u00fc\u00e7\u00fcn\u00fc col_index_num olarak belirttik. Ancak arama tablosunda yaln\u0131zca iki s\u00fctunumuz var ve bu y\u00fczden #REF! Sonu\u00e7ta hata. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82507\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ref-erreur-dans-le-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"sonu\u00e7taki ref hatas\u0131\" width=\"526\" height=\"279\"><\/figure><\/div><p> INDEX&#8217;i kullanarak da ayn\u0131 \u015feyle kar\u015f\u0131la\u015fabilirsiniz. Ba\u015fvurulan verilerdeki toplam s\u00fctun veya sat\u0131r say\u0131s\u0131ndan daha b\u00fcy\u00fck bir sat\u0131r veya s\u00fctun numaras\u0131 aramaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda #REF! Sonu\u00e7ta hata. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82508\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-erreur-de-reference-lors-de-lutilisation-de-lindex.png\" sizes=\"auto, \" srcset=\"\" alt=\"ref-hata-kullan\u0131rken-index\" width=\"470\" height=\"310\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte aral\u0131\u011f\u0131n 7. sat\u0131r\u0131ndaki de\u011feri ar\u0131yoruz ancak toplamda sadece 6 h\u00fccremiz var.<\/p><h2 id=\"h-ref-error-when-you-delete-a-column\" class=\"wp-block-heading\"> #REF! S\u00fctun silinirken hata olu\u015ftu<\/h2><p> A\u015fa\u011f\u0131daki \u00f6rnekte A1:C3 aral\u0131\u011f\u0131n\u0131 \u00fc\u00e7 par\u00e7a olarak adland\u0131rd\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82509\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-erreur-de-reference-lors-de-la-suppression-dune-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"ref-hata-bir-s\u00fctun-silildi\u011finde\" width=\"474\" height=\"395\"><\/figure><\/div><p> Ancak bu s\u00fctunlardan birini kald\u0131r\u0131rsan\u0131z form\u00fcl #BA\u015eV! sonucunu d\u00f6nd\u00fcr\u00fcr. Sonu\u00e7ta hata. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82510\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-la-formule-renvoie-une-erreur-de-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"form\u00fcl-d\u00f6nd\u00fcr\u00fcr-ref-hata\" width=\"484\" height=\"330\"><\/figure><\/div><h2 id=\"h-other-reasons\" class=\"wp-block-heading\"> Di\u011fer sebepler<\/h2><p> DOLAYLI i\u015flevini kullan\u0131rken kapal\u0131 bir \u00e7al\u0131\u015fma kitab\u0131ndaki bir h\u00fccreye veya aral\u0131\u011fa ba\u015fvuruyorsan\u0131z. #REF alma \u015fans\u0131n\u0131z var! Sonu\u00e7ta hata. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82511\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-ref-erreur-avec-fonction-indirecte.png\" sizes=\"auto, \" srcset=\"\" alt=\"dolayl\u0131-i\u015flevli ref-hata\" width=\"665\" height=\"284\"><\/figure><\/div><h2 id=\"h-fixing-the-ref-error\" class=\"wp-block-heading\"> #REF&#8217;in d\u00fczeltilmesi! Hata<\/h2><p> Excel&#8217;de form\u00fcllerle \u00e7al\u0131\u015f\u0131rken #REF! ISERROR veya ba\u015fka bir i\u015flevde hata. Hatay\u0131 sonu\u00e7 olarak ald\u0131\u011f\u0131n\u0131zda d\u00fczeltmek daha iyidir.<\/p><p> \u00c7o\u011fu durumda referans\u0131 aral\u0131\u011fa veya h\u00fccreye ayarlaman\u0131z gerekir; form\u00fclleriniz do\u011fru \u015fekilde \u00e7al\u0131\u015facakt\u0131r. Ancak bazen tam olarak hangi referans\u0131n kald\u0131r\u0131ld\u0131\u011f\u0131n\u0131 veya kald\u0131r\u0131ld\u0131\u011f\u0131n\u0131 bilmek zor olabilir.<\/p><p> \u00d6rne\u011fin, \u00e7al\u0131\u015fma kitab\u0131ndan bir sayfay\u0131 sildi\u011finizde bu eylemi geri almak imkans\u0131zd\u0131r ve bu referanslar\u0131 form\u00fclde de\u011fi\u015ftirmek daha zordur.<\/p><h2 id=\"h-finding-all-the-ref-errors\" class=\"wp-block-heading\"> T\u00fcm #REF&#8217;leri bulun! Hatalar<\/h2><p> Excel&#8217;in BUL se\u00e7ene\u011fi yard\u0131m\u0131yla #BA\u015eV! i\u015faretinin bulundu\u011fu h\u00fccreleri bulabilir ve se\u00e7ebilirsiniz. Hata.<\/p><ol type=\"1\"><li> Crtl + F tu\u015flar\u0131n\u0131 kullanarak Bul ve De\u011fi\u015ftir&#8217;i a\u00e7\u0131n.<\/li><li> #REF de\u011ferini girin! &#8220;Ne Bul&#8221; b\u00f6l\u00fcm\u00fcnde.<\/li><li> \u201cSe\u00e7enekler\u201d d\u00fc\u011fmesine t\u0131klay\u0131n.<\/li><li> &#8220;Arama&#8221; b\u00f6l\u00fcm\u00fcnde &#8220;De\u011ferler&#8221;i se\u00e7in.<\/li><li> \u201cT\u00fcm\u00fcn\u00fc Ara\u201d butonuna t\u0131klay\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82512\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-trouver-toutes-les-erreurs-de-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"t\u00fcm referans hatalar\u0131n\u0131 bul\" width=\"655\" height=\"418\"><\/figure><\/div><p> Bundan sonra her h\u00fccreye giderek form\u00fcl\u00fc d\u00fczeltebilirsiniz. <\/p><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Excel dosyas\u0131n\u0131 al\u0131n <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ref.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/div><\/div><\/div><\/div><\/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\/dokulme-hatasi\/\">#YAYILMAK! Hata<\/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><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hata-yok\/\">#Yok Hata<\/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-2173","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>#REF nas\u0131l d\u00fczeltilir? Excel&#039;de hata m\u0131 var? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim #REF&#039;i anlaman\u0131za yard\u0131mc\u0131 olacakt\u0131r! Excel form\u00fcl\u00fcndeki hata ve d\u00fczeltmenin yollar\u0131. Bunu kontrol edelim\u2026\" \/>\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\/referans-hatasi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"#REF nas\u0131l d\u00fczeltilir? Excel&#039;de hata m\u0131 var? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim #REF&#039;i anlaman\u0131za yard\u0131mc\u0131 olacakt\u0131r! Excel form\u00fcl\u00fcndeki hata ve d\u00fczeltmenin yollar\u0131. Bunu kontrol edelim\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/referans-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-erreur-de-reference-dans-excel.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\/referans-hatasi\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/\",\"name\":\"#REF 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\/referans-hatasi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-reference-dans-excel.png\",\"datePublished\":\"2023-09-26T05:13:14+00:00\",\"dateModified\":\"2023-12-10T05:58:30+00:00\",\"description\":\"Bu e\u011fitim #REF&#39;i anlaman\u0131za yard\u0131mc\u0131 olacakt\u0131r! Excel form\u00fcl\u00fcndeki hata ve d\u00fczeltmenin yollar\u0131. Bunu kontrol edelim\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-reference-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-reference-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"#ref 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":"#REF nas\u0131l d\u00fczeltilir? Excel&#39;de hata m\u0131 var? (E\u011fitim 2023)","description":"Bu e\u011fitim #REF&#39;i anlaman\u0131za yard\u0131mc\u0131 olacakt\u0131r! Excel form\u00fcl\u00fcndeki hata ve d\u00fczeltmenin yollar\u0131. Bunu kontrol edelim\u2026","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\/referans-hatasi\/","og_locale":"tr_TR","og_type":"article","og_title":"#REF nas\u0131l d\u00fczeltilir? Excel&#39;de hata m\u0131 var? (E\u011fitim 2023)","og_description":"Bu e\u011fitim #REF&#39;i anlaman\u0131za yard\u0131mc\u0131 olacakt\u0131r! Excel form\u00fcl\u00fcndeki hata ve d\u00fczeltmenin yollar\u0131. Bunu kontrol edelim\u2026","og_url":"https:\/\/exceladvisor.org\/tr\/referans-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-erreur-de-reference-dans-excel.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\/referans-hatasi\/","url":"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/","name":"#REF 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\/referans-hatasi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-reference-dans-excel.png","datePublished":"2023-09-26T05:13:14+00:00","dateModified":"2023-12-10T05:58:30+00:00","description":"Bu e\u011fitim #REF&#39;i anlaman\u0131za yard\u0131mc\u0131 olacakt\u0131r! Excel form\u00fcl\u00fcndeki hata ve d\u00fczeltmenin yollar\u0131. Bunu kontrol edelim\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/referans-hatasi\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-reference-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-reference-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"#ref 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\/2173","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=2173"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2173\/revisions"}],"predecessor-version":[{"id":2249,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2173\/revisions\/2249"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}