{"id":1739,"date":"2023-11-08T12:16:26","date_gmt":"2023-11-08T12:16:26","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/"},"modified":"2023-12-10T06:01:06","modified_gmt":"2023-12-10T06:01:06","slug":"dinamik-liste","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/","title":{"rendered":"Excel&#39;de dinamik bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2125799604\"><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>Liste g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Veri giri\u015finizi basit ve h\u0131zl\u0131 yapman\u0131za yard\u0131mc\u0131 olabilir. Kontrol panelleriniz, grafikleriniz ve hatta normal verilerle birlikte bir a\u00e7\u0131l\u0131r liste kullanabilirsiniz.<\/p><p> Bunu kullanmak beni her zaman \u00e7\u0131lg\u0131na \u00e7eviren bir \u015fey olsa da, her yeni giri\u015f ekledi\u011finizde veri kayna\u011f\u0131n\u0131 g\u00fcncellemeniz gerekiyor. Ne kadar \u00e7ok veri eklerseniz, o kadar s\u0131k g\u00fcncellemeniz gerekir.<\/p><p> Bunun i\u00e7in en iyi \u00e7\u00f6z\u00fcm, veri kayna\u011f\u0131n\u0131 tekrar tekrar g\u00fcncellemenize gerek olmayan <span style=\"background-color: #ffff00;\"><strong><span style=\"color: #000000;\">dinamik<\/span><\/strong><\/span> bir liste kullanmakt\u0131r. Ama \u00f6nce size a\u00e7\u0131l\u0131r listenizin neden dinamik olmas\u0131 gerekti\u011fini a\u00e7\u0131klayan bir \u00f6rnek g\u00f6stereyim. A\u015fa\u011f\u0131daki \u00f6rnekte ayn\u0131 veri kayna\u011f\u0131n\u0131 kulland\u0131\u011f\u0131m\u0131z iki farkl\u0131 a\u00e7\u0131l\u0131r listemiz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Difference-entre-la-liste-deroulante-dynamique-dans-Excel-et-la-liste-deroulante-normale-1.gif\" sizes=\"\" srcset=\"\" alt=\"Excel'deki dinamik a\u00e7\u0131l\u0131r liste ile normal a\u00e7\u0131l\u0131r liste aras\u0131ndaki fark\"><\/figure><\/div><p> Kaynak listesine yeni bir giri\u015f ekledi\u011finizde, bu giri\u015f ikinci a\u00e7\u0131l\u0131r listede otomatik olarak g\u00fcncellenir.<\/p><p> Ancak normal a\u00e7\u0131l\u0131r listede herhangi bir de\u011fi\u015fiklik yok. Ayr\u0131ca listenizi g\u00fcncellemek istiyorsan\u0131z veri kayna\u011f\u0131 aral\u0131\u011f\u0131n\u0131z\u0131 g\u00fcncellemeniz gerekir.<\/p><p class=\"mynote\"> Excel 2007 veya sonraki bir s\u00fcr\u00fcm\u00fcn\u00fc kullan\u0131yorsan\u0131z bir Excel tablosu kullanabilirsiniz; h\u00e2l\u00e2 Excel 2003 kullan\u0131yorsan\u0131z adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> 1. Dinamik A\u00e7\u0131l\u0131r Liste Olu\u015fturmak i\u00e7in Excel Tablosunu Kullanma<\/h2><p> Dinamik bir a\u00e7\u0131l\u0131r liste olu\u015fturman\u0131n en iyi y\u00f6ntemi, kaynak veriler i\u00e7in bir Excel tablosu kullanmakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-a-utiliser-pour-creer-une-liste-deroulante-dynamique-dans-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de dinamik bir a\u00e7\u0131l\u0131r liste olu\u015fturmak i\u00e7in kullan\u0131lacak liste.\"><\/figure><\/div><p> Excel&#8217;de dinamik bir a\u00e7\u0131l\u0131r liste olu\u015fturman\u0131n basit ad\u0131mlar\u0131 a\u015fa\u011f\u0131da verilmi\u015ftir.<\/p><ul><li> \u00d6ncelikle normal aral\u0131\u011f\u0131n\u0131z\u0131 bir dizi olarak de\u011fi\u015ftirin.<ul><li> Listenizi se\u00e7in.<\/li><li> \u279c Tablo Ekle \u279c Tablolar \u279c Tablo&#8217;ya gidin.<\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-un-tableau-pour-creer-une-liste-deroulante-dynamique-dans-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de dinamik bir a\u00e7\u0131l\u0131r liste olu\u015fturmak i\u00e7in bir tablo uygulay\u0131n\"><\/figure><\/div><ul><li> \u015eimdi bir sonraki ad\u0131m tablo aral\u0131\u011f\u0131 veri kayna\u011f\u0131na ba\u015fvurmak ve bunun i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanmam\u0131z gerekiyor. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-la-fonction-indirecte-pour-faire-reference-a-la-plage-de-la-table-pour-creer-une-liste-deroulante-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"dinamik a\u00e7\u0131l\u0131r liste olu\u015fturmak amac\u0131yla tablo aral\u0131\u011f\u0131na ba\u015fvurmak i\u00e7in dolayl\u0131 i\u015flevi kullan\u0131n\"><\/figure><\/div><p> =DOLAYLI(\u201cTablo5[Ay]\u201d)<\/p><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Art\u0131k kaynak listenizi g\u00fcncelledi\u011finizde an\u0131nda g\u00fcncellenecek dinamik bir listeniz var.<\/p><p class=\"myalert\"> Kaynak olarak do\u011frudan tablo aral\u0131\u011f\u0131na ba\u015fvurmaya \u00e7al\u0131\u015f\u0131rsan\u0131z a\u015fa\u011f\u0131daki gibi bir hata d\u00f6nd\u00fcr\u00fcl\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/erreur-lors-de-la-reference-a-la-plage-du-tableau-pour-creer-une-liste-deroulante-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Dinamik a\u00e7\u0131l\u0131r men\u00fc olu\u015fturmak i\u00e7in dizi aral\u0131\u011f\u0131na ba\u015fvururken hata olu\u015ftu\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 2. OFFSET i\u015flevine sahip bir a\u00e7\u0131l\u0131r liste i\u00e7in dinamik aral\u0131k<\/h2><p> Hala Excel 2003 veya \u00f6nceki bir s\u00fcr\u00fcm\u00fcn\u00fc kullan\u0131yorsan\u0131z, dinamik aral\u0131k olu\u015fturmak i\u00e7in kayd\u0131rma i\u015flevini kullanabilirsiniz ve ard\u0131ndan bu dinamik aral\u0131\u011f\u0131, a\u00e7\u0131l\u0131r liste olu\u015fturmak i\u00e7in kullanabilirsiniz. Dinamik aral\u0131\u011f\u0131 kullanarak a\u00e7\u0131l\u0131r liste olu\u015fturman\u0131n basit ad\u0131mlar\u0131 a\u015fa\u011f\u0131da verilmi\u015ftir.<\/p><ul><li> Form\u00fcller&#8217;e gidin \u279c Tan\u0131ml\u0131 Adlar \u279c Ad Y\u00f6neticisi \u279c Yeni&#8217;ye t\u0131klay\u0131n.<\/li><li> Ad giri\u015f kutusuna adland\u0131r\u0131lm\u0131\u015f aral\u0131k i\u00e7in bir ad girin (burada \u201cmonthList2003\u201d kullan\u0131yorum).<\/li><li> A\u015fa\u011f\u0131daki form\u00fcl\u00fc \u201cReferans\u201d alan\u0131na girin ve Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-dynamique-pour-creer-une-liste-deroulante-pour-Excel-2003-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel 2003 i\u00e7in a\u00e7\u0131l\u0131r liste olu\u015fturmak \u00fczere dinamik aral\u0131k olu\u015fturun\"><\/figure><\/div><ul><li> Art\u0131k &#8220;monthList2003&#8221; dinamik aral\u0131\u011f\u0131n\u0131z var ve dinamik bir a\u00e7\u0131l\u0131r liste olu\u015fturmak i\u00e7in bu aral\u0131k ad\u0131n\u0131 kullanabilirsiniz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-la-plage-dynamique-pour-creer-une-liste-deroulante-dynamique-pour-2003-1.png\" sizes=\"\" srcset=\"\" alt=\"2003 i\u00e7in dinamik bir a\u00e7\u0131l\u0131r men\u00fc olu\u015fturmak i\u00e7in dinamik aral\u0131\u011f\u0131 kullan\u0131n\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Bu nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Dinamik aral\u0131k olu\u015fturmak i\u00e7in kulland\u0131\u011f\u0131m\u0131z form\u00fcl, listedeki de\u011ferleri sayacak ve kaynak aral\u0131\u011f\u0131n\u0131 buna g\u00f6re geni\u015fletecektir. Bu, a\u00e7\u0131l\u0131r listenizi dinamik hale getirecektir.<\/p><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/liste-deroulante-dynamique-dans-excel.xlsx\" rel=\"nofollow\"><em>\u00f6rnek dosya<\/em><\/a><\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/excel-ilerlemesi\/\">\u0130leri Excel Dersleri<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/veri-dogrulama-tarih-araligi\/\">Tarih aral\u0131\u011f\u0131yla veri do\u011frulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/\">Excel&#8217;deki ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/evet-hayir-acilir-liste\/\">Excel&#8217;de Evet &#8211; Hay\u0131r A\u00e7\u0131l\u0131r Listesi Olu\u015fturma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/acilir-listeyi-kaldir\/\">Excel&#8217;de a\u00e7\u0131l\u0131r listeyi (veri do\u011frulama) kald\u0131r<\/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-1739","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>Excel&#039;de dinamik bir liste nas\u0131l olu\u015fturulur? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"A\u00e7\u0131l\u0131r liste g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Ama onu kullan\u0131rken beni her zaman deli eden bir \u015fey var, kayna\u011f\u0131n\u0131 g\u00fcncellemem gerekiyor\" \/>\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\/dinamik-liste\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de dinamik bir liste nas\u0131l olu\u015fturulur? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"A\u00e7\u0131l\u0131r liste g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Ama onu kullan\u0131rken beni her zaman deli eden bir \u015fey var, kayna\u011f\u0131n\u0131 g\u00fcncellemem gerekiyor\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Difference-entre-la-liste-deroulante-dynamique-dans-Excel-et-la-liste-deroulante-normale-1.gif\" \/>\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\/dinamik-liste\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/\",\"name\":\"Excel&#39;de dinamik bir liste nas\u0131l olu\u015fturulur? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Difference-entre-la-liste-deroulante-dynamique-dans-Excel-et-la-liste-deroulante-normale-1.gif\",\"datePublished\":\"2023-11-08T12:16:26+00:00\",\"dateModified\":\"2023-12-10T06:01:06+00:00\",\"description\":\"A\u00e7\u0131l\u0131r liste g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Ama onu kullan\u0131rken beni her zaman deli eden bir \u015fey var, kayna\u011f\u0131n\u0131 g\u00fcncellemem gerekiyor\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Difference-entre-la-liste-deroulante-dynamique-dans-Excel-et-la-liste-deroulante-normale-1.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Difference-entre-la-liste-deroulante-dynamique-dans-Excel-et-la-liste-deroulante-normale-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de dinamik bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?\"}]},{\"@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":"Excel&#39;de dinamik bir liste nas\u0131l olu\u015fturulur? (E\u011fitim 2023)","description":"A\u00e7\u0131l\u0131r liste g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Ama onu kullan\u0131rken beni her zaman deli eden bir \u015fey var, kayna\u011f\u0131n\u0131 g\u00fcncellemem gerekiyor","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\/dinamik-liste\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de dinamik bir liste nas\u0131l olu\u015fturulur? (E\u011fitim 2023)","og_description":"A\u00e7\u0131l\u0131r liste g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Ama onu kullan\u0131rken beni her zaman deli eden bir \u015fey var, kayna\u011f\u0131n\u0131 g\u00fcncellemem gerekiyor","og_url":"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:06+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Difference-entre-la-liste-deroulante-dynamique-dans-Excel-et-la-liste-deroulante-normale-1.gif","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\/dinamik-liste\/","url":"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/","name":"Excel&#39;de dinamik bir liste nas\u0131l olu\u015fturulur? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Difference-entre-la-liste-deroulante-dynamique-dans-Excel-et-la-liste-deroulante-normale-1.gif","datePublished":"2023-11-08T12:16:26+00:00","dateModified":"2023-12-10T06:01:06+00:00","description":"A\u00e7\u0131l\u0131r liste g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Ama onu kullan\u0131rken beni her zaman deli eden bir \u015fey var, kayna\u011f\u0131n\u0131 g\u00fcncellemem gerekiyor","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/dinamik-liste\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Difference-entre-la-liste-deroulante-dynamique-dans-Excel-et-la-liste-deroulante-normale-1.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Difference-entre-la-liste-deroulante-dynamique-dans-Excel-et-la-liste-deroulante-normale-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de dinamik bir a\u00e7\u0131l\u0131r liste nas\u0131l olu\u015fturulur?"}]},{"@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\/1739","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=1739"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1739\/revisions"}],"predecessor-version":[{"id":2470,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1739\/revisions\/2470"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}