{"id":2063,"date":"2023-10-21T10:50:35","date_gmt":"2023-10-21T10:50:35","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/"},"modified":"2023-12-10T06:07:26","modified_gmt":"2023-12-10T06:07:26","slug":"araligi-sirala","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/","title":{"rendered":"Vba&#39;da aral\u0131k nas\u0131l s\u0131ralan\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1207617382\"><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>VBA kullanarak bir h\u00fccre aral\u0131\u011f\u0131n\u0131 s\u0131ralamak i\u00e7in, s\u0131ralamak \u00fczere tek bir anahtar (s\u00fctun) veya birden \u00e7ok anahtar (birden fazla s\u00fctun i\u00e7in) ayarlaman\u0131za olanak tan\u0131yan &#8220;SIRALAMA&#8221; y\u00f6ntemini kullanman\u0131z gerekir. Ayr\u0131ca s\u0131ralamak istedi\u011finiz s\u0131ray\u0131 (artan veya azalan) ayarlayabilir ve ba\u015fl\u0131\u011f\u0131n\u0131z\u0131n olup olmad\u0131\u011f\u0131n\u0131 belirtebilirsiniz.<\/p><h2 class=\"wp-block-heading\"> VBA ile bir aral\u0131\u011f\u0131 s\u0131ralama<\/h2><ol type=\"1\"><li> S\u0131ralamak istedi\u011finiz aral\u0131\u011f\u0131 belirtmek i\u00e7in aral\u0131k nesnesini kullan\u0131n.<\/li><li> Bir nokta yaz\u0131n ve s\u0131ralama y\u00f6ntemini girin.<\/li><li> S\u0131ralama i\u00e7in kullanmak istedi\u011finiz anahtar\u0131 belirtin.<\/li><li> S\u0131ralama d\u00fczenini ayarlay\u0131n.<\/li><li> Ba\u015fl\u0131\u011f\u0131n\u0131z\u0131n olup olmad\u0131\u011f\u0131n\u0131 belirtin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54924\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir aral\u0131\u011f\u0131 vba'ya g\u00f6re s\u0131ralama\" width=\"690\" height=\"296\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A11\").Sort Key1:=Range(\"A1\"), _ Order1:=xlAscending, _ Header:=xlYes<\/code><\/pre><p> Yukar\u0131daki kodda A1:A11 aral\u0131\u011f\u0131n\u0131 kulland\u0131n\u0131z ve artan d\u00fczende kulland\u0131\u011f\u0131n\u0131z s\u0131ralama y\u00f6nteminde aral\u0131kta bir ba\u015fl\u0131\u011f\u0131n\u0131z oldu\u011fundan bahsettiniz.<\/p><h2 class=\"wp-block-heading\"> VBA&#8217;n\u0131n s\u0131ralama y\u00f6ntemini anlama<\/h2><p> Bir aral\u0131\u011f\u0131 s\u0131ralamak i\u00e7in bir makro yazmadan \u00f6nce, s\u0131ralama y\u00f6ntemini derinlemesine incelemek ve arg\u00fcmanlar\u0131n\u0131 anlamak en iyisidir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sort (Key1, Order1, Key2, Type, Order2, Key3, Order3, _ Header, OrderCustom, MatchCase, Orientation, SortMethod, _ DataOption1, DataOption2, DataOption3)<\/code><\/pre><p> \u0130\u015fte ger\u00e7ek hayatta kullanaca\u011f\u0131n\u0131z en \u00f6nemli arg\u00fcmanlar.<\/p><ul><li> <strong>Anahtar<\/strong> : Burada s\u00fctununu s\u0131ralama temeli olarak kullanmak istedi\u011finiz h\u00fccreyi tan\u0131mlaman\u0131z gerekir.<\/li><li> <strong>S\u0131ralama<\/strong> : S\u00fctunu s\u0131ralamak istedi\u011finiz s\u0131ra (artan\/azalan).<\/li><li> <strong>Ba\u015fl\u0131k<\/strong> : Bir ba\u015fl\u0131\u011f\u0131n\u0131z\u0131n olup olmad\u0131\u011f\u0131n\u0131 veya VBA&#8217;n\u0131n tahmin etmesini isteyip istemedi\u011finizi belirten bir sabit.<\/li><\/ul><h2 class=\"wp-block-heading\"> Azalan d\u00fczende s\u0131rala<\/h2><p> A\u015fa\u011f\u0131daki kodda, miktar s\u00fctununu azalan d\u00fczende s\u0131ralamak i\u00e7in &#8216;xlDescending&#8217;i kulland\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54925\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-tri-decroissant.png\" sizes=\"auto, \" srcset=\"\" alt=\"Azalan d\u00fczende s\u0131rala\" width=\"498\" height=\"216\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A13\").Sort Key1:=Range(\"A1\"), _ Order1:=xlDescending, _ Orientation:=xlSortColumns<\/code><\/pre><h2 class=\"wp-block-heading\"> S\u0131ralamak i\u00e7in birden fazla s\u00fctun (anahtar) kullanma<\/h2><p> Bir aral\u0131\u011f\u0131 s\u0131ralamak i\u00e7in birden \u00e7ok s\u00fctun da kullanabilirsiniz. A\u015fa\u011f\u0131daki tablodan, \u00e7al\u0131\u015fan adlar\u0131 ve \u015fehirleri i\u00e7eren birden fazla giri\u015finizin oldu\u011fu ve ad\u0131 ve \u015fehri kullanarak s\u0131ralama yapman\u0131z gereken bir \u00f6rne\u011fi ele alal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54926\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-utiliser-plusieurs-colonnes-pour-trier.png\" sizes=\"auto, \" srcset=\"\" alt=\"S\u0131ralamak i\u00e7in birden fazla s\u00fctun kullan\u0131n\" width=\"371\" height=\"410\"><\/figure><\/div><p> Kullanman\u0131z gereken kod a\u015fa\u011f\u0131dad\u0131r: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54927\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-codes-pour-plusieurs-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"birden fazla s\u00fctun i\u00e7in kodlar\" width=\"538\" height=\"276\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:C13\").Sort Key1:=Range(\"A1\"), _ Order1:=xlAscending, _ Key2:=Range(\"B1\"), _ Order1:=xlAscending, _ Header:=xlYes<\/code><\/pre><p> Kodda g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi key1 ve key2&#8217;ye sahipsiniz. Anahtar1&#8217;de \u00e7al\u0131\u015fan ad\u0131n\u0131n bulundu\u011fu s\u00fctun var ve anahtar2&#8217;de \u015fehir s\u00fctunu var. Her iki s\u00fctun i\u00e7in de s\u0131ralama d\u00fczeni artan \u015fekildedir ve ba\u015fl\u0131klar oradad\u0131r.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> Bunu, anahtarlar\u0131 ve d\u00fczeni kullanarak s\u0131ralama yapmak i\u00e7in temel olarak kullanmak istedi\u011finiz herhangi bir s\u00fctun olarak kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Kader y\u00f6n\u00fcn\u00fc de\u011fi\u015ftirme<\/h2><p> Normalde Excel&#8217;de verileri s\u0131ralad\u0131\u011f\u0131n\u0131zda, varsay\u0131lan olarak s\u00fctunlar\u0131 kullanarak s\u0131ralama yapabilirsiniz. Ancak s\u0131ralama se\u00e7eneklerinden s\u0131ralama y\u00f6n\u00fcn\u00fc yukar\u0131dan a\u015fa\u011f\u0131ya yerine soldan sa\u011fa de\u011fi\u015ftirebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54928\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-trier-lorientation.png\" sizes=\"auto, \" srcset=\"\" alt=\"kader y\u00f6nelimi\" width=\"494\" height=\"230\"><\/figure><\/div><p> Benzer \u015fekilde, s\u0131ralama y\u00f6nteminde y\u00f6nlendirmeyi ( <a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.xlsortorientation\" target=\"_blank\" rel=\"noreferrer noopener\">link<\/a> ) de\u011fi\u015ftirmek i\u00e7in bir arg\u00fcman\u0131n\u0131z var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54929\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-methodes-pour-trier-lorientation.png\" sizes=\"auto, \" srcset=\"\" alt=\"y\u00f6nlendirmeyi s\u0131ralama y\u00f6ntemi\" width=\"642\" height=\"275\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:C13\").Sort Key1:=Range(\"A1\"), _ Order1:=xlAscending, _ Orientation:=xlSortRows<\/code><\/pre><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\/vba\/\">VBA nedir<\/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-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> VBA Ekleme S\u00fctunu (Tekli ve \u00c7oklu)<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/isimli-plaj\/\">Aral\u0131k adl\u0131 VBA | (Statik + Se\u00e7im + Dinamik)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/menzil-kaymasi\/\">VBA Aral\u0131\u011f\u0131 Uzakl\u0131\u011f\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metni-kaydir-1\/\">VBA Sarma Metni (h\u00fccre, aral\u0131k ve \u00e7al\u0131\u015fma sayfas\u0131n\u0131n tamam\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/\">VBA Bir h\u00fccrenin bo\u015f + birden fazla h\u00fccre olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/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-2063","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 VBA&#039;da aral\u0131k nas\u0131l s\u0131ralan\u0131r? (Azalan, S\u0131ralama Y\u00f6n\u00fc)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, VBA kullanarak tek s\u00fctunu, birden \u00e7ok s\u00fctunu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z ve s\u0131ralama y\u00f6n\u00fcn\u00fc nas\u0131l de\u011fi\u015ftirece\u011finiz g\u00f6sterilir.\" \/>\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\/araligi-sirala\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 VBA&#039;da aral\u0131k nas\u0131l s\u0131ralan\u0131r? (Azalan, S\u0131ralama Y\u00f6n\u00fc)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, VBA kullanarak tek s\u00fctunu, birden \u00e7ok s\u00fctunu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z ve s\u0131ralama y\u00f6n\u00fcn\u00fc nas\u0131l de\u011fi\u015ftirece\u011finiz g\u00f6sterilir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.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\/araligi-sirala\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/\",\"name\":\"\u25b7 VBA&#39;da aral\u0131k nas\u0131l s\u0131ralan\u0131r? (Azalan, S\u0131ralama Y\u00f6n\u00fc)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png\",\"datePublished\":\"2023-10-21T10:50:35+00:00\",\"dateModified\":\"2023-12-10T06:07:26+00:00\",\"description\":\"Bu e\u011fitimde, VBA kullanarak tek s\u00fctunu, birden \u00e7ok s\u00fctunu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z ve s\u0131ralama y\u00f6n\u00fcn\u00fc nas\u0131l de\u011fi\u015ftirece\u011finiz g\u00f6sterilir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba&#39;da aral\u0131k nas\u0131l s\u0131ralan\u0131r?\"}]},{\"@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 VBA&#39;da aral\u0131k nas\u0131l s\u0131ralan\u0131r? (Azalan, S\u0131ralama Y\u00f6n\u00fc)","description":"Bu e\u011fitimde, VBA kullanarak tek s\u00fctunu, birden \u00e7ok s\u00fctunu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z ve s\u0131ralama y\u00f6n\u00fcn\u00fc nas\u0131l de\u011fi\u015ftirece\u011finiz g\u00f6sterilir.","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\/araligi-sirala\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 VBA&#39;da aral\u0131k nas\u0131l s\u0131ralan\u0131r? (Azalan, S\u0131ralama Y\u00f6n\u00fc)","og_description":"Bu e\u011fitimde, VBA kullanarak tek s\u00fctunu, birden \u00e7ok s\u00fctunu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z ve s\u0131ralama y\u00f6n\u00fcn\u00fc nas\u0131l de\u011fi\u015ftirece\u011finiz g\u00f6sterilir.","og_url":"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.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\/araligi-sirala\/","url":"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/","name":"\u25b7 VBA&#39;da aral\u0131k nas\u0131l s\u0131ralan\u0131r? (Azalan, S\u0131ralama Y\u00f6n\u00fc)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png","datePublished":"2023-10-21T10:50:35+00:00","dateModified":"2023-12-10T06:07:26+00:00","description":"Bu e\u011fitimde, VBA kullanarak tek s\u00fctunu, birden \u00e7ok s\u00fctunu nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z ve s\u0131ralama y\u00f6n\u00fcn\u00fc nas\u0131l de\u011fi\u015ftirece\u011finiz g\u00f6sterilir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/araligi-sirala\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba&#39;da aral\u0131k nas\u0131l s\u0131ralan\u0131r?"}]},{"@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\/2063","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=2063"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2063\/revisions"}],"predecessor-version":[{"id":2930,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2063\/revisions\/2930"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}