{"id":1780,"date":"2023-11-05T07:22:56","date_gmt":"2023-11-05T07:22:56","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/"},"modified":"2023-12-10T05:59:16","modified_gmt":"2023-12-10T05:59:16","slug":"2-hucrenin-adresini-bul","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/","title":{"rendered":"De\u011fer yerine h\u00fccre adresini bulma"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2297357092\"><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 h\u00fccreyi arayabilir ve h\u00fccrenin de\u011feri yerine h\u00fccre adresini alabilirsiniz. Diyelim ki B12 h\u00fccresinde kar\u015f\u0131l\u0131k gelen de\u011fere sahipsiniz. Form\u00fcl ile B12 adresini de\u011fil de\u011ferini alabilirsiniz.<\/p><p> Bu e\u011fitimde bunun i\u00e7in bir form\u00fcl yazman\u0131n olas\u0131 yollar\u0131na bakaca\u011f\u0131z.<\/p><h2 class=\"wp-block-heading\"> De\u011fer yerine h\u00fccre adresini al\u0131n (H\u00dcCRE + INDEX + MATCH)<\/h2><p> Bu form\u00fcl\u00fc yazmak i\u00e7in l\u00fctfen a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin:<\/p><ol><li> \u0130lk olarak, bir h\u00fccreye H\u00dcCRE fonksiyonunu girin ve ilk arg\u00fcmanda &#8220;adres&#8221;i bilgi_t\u00fcr\u00fc olarak belirtin. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-h\u00fccre-adresini al\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-ladresse-cellulaire.png\" sizes=\"auto, \" srcset=\"\" alt=\"get-cell-address\" width=\"493\" height=\"177\"><\/li><li> Bundan sonra ikinci arg\u00fcmana INDEX fonksiyonunu girin. <br><img loading=\"lazy\" decoding=\"async\" title=\"Saniyede 2 ba\u011f\u0131ms\u0131z de\u011fi\u015fken enter indeksi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-dans-le-deuxieme-argument-entrez-lindex.png\" sizes=\"auto, \" srcset=\"\" alt=\"in-second-argument-enter-index\" width=\"526\" height=\"179\"><\/li><li> Daha sonra, INDEX&#8217;in dizi ba\u011f\u0131ms\u0131z de\u011fi\u015fkeninde A s\u00fctunundaki adlara bak\u0131n. Aral\u0131k A2:A1001 olacakt\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-dizi-indeks-arg\u00fcman\u0131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-arguments-de-tableau-dindex.png\" sizes=\"auto, \" srcset=\"\" alt=\"array-argument-of-index\" width=\"642\" height=\"207\"><\/li><li> \u015eimdi INDEX&#8217;in ikinci arg\u00fcman\u0131na MATCH fonksiyonunu girin. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-e\u015fle\u015fmeye girme i\u015flevi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-entrez-la-fonction-de-correspondance.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-match-function\" width=\"663\" height=\"229\"><\/li><li> Buradan, MATCH&#8217;te, aranan_de\u011fer ba\u011f\u0131ms\u0131z de\u011fi\u015fkeninde arama de\u011ferini belirtin ve aranan_dizi ba\u011f\u0131ms\u0131z de\u011fi\u015fkeninde A2:A1001 aral\u0131\u011f\u0131na tekrar ba\u015fvurun. Tam bir e\u015fle\u015fme ger\u00e7ekle\u015ftirmek i\u00e7in [match_type] ba\u011f\u0131ms\u0131z de\u011fi\u015fkeninde 0&#8217;\u0131 kullan\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-e\u015fle\u015fme-arama-de\u011ferini-belirtin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-match-specifiez-la-valeur-de-recherche.png\" sizes=\"auto, \" srcset=\"\" alt=\"match-specify-the-lookup-value\" width=\"762\" height=\"232\"><\/li><li> Sonunda kapatma parantezlerini girin ve sonucu almak i\u00e7in Enter tu\u015funa bas\u0131n.<\/li><\/ol><p> Enter tu\u015funa bast\u0131\u011f\u0131n\u0131zda arad\u0131\u011f\u0131n\u0131z de\u011ferin h\u00fccre adresini d\u00f6nd\u00fcrecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80564\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-adresse-de-cellule-obtenue.png\" sizes=\"auto, \" srcset=\"\" alt=\"elde edilen h\u00fccre adresi\" width=\"489\" height=\"383\"><\/figure><\/div><p> &#8220;Alec Wright&#8221; ad\u0131 A5 h\u00fccresindedir ve sonu\u00e7ta bu ad\u0131 g\u00f6r\u00fcrs\u00fcn\u00fcz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CELL(\"address\",INDEX(A2:A1001,MATCH(C1,A2:A1001,0)))<\/code><\/pre><h2 class=\"wp-block-heading\"> Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h2><p> Bu form\u00fcl\u00fc anlamak i\u00e7in <strong>onu \u00fc\u00e7 par\u00e7aya b\u00f6lmeniz<\/strong> gerekiyor \u00e7\u00fcnk\u00fc \u00fc\u00e7 fonksiyon kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80565\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-cracher-la-formule-en-trois-parties.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00fc\u00e7 par\u00e7al\u0131 form\u00fcl\u00fc t\u00fck\u00fcr\" width=\"687\" height=\"116\"><\/figure><\/div><p> \u0130lk b\u00f6l\u00fcmde A2:A1001 h\u00fccre isminin arama de\u011feriyle e\u015fle\u015fen ve sonu\u00e7taki konum numaras\u0131n\u0131 d\u00f6nd\u00fcren MATCH fonksiyonumuz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80566\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-premiere-partie-a-une-fonction-de-correspondance.png\" sizes=\"auto, \" srcset=\"\" alt=\"ilk b\u00f6l\u00fcm\u00fcn e\u015fle\u015ftirme i\u015flevi vard\u0131r\" width=\"560\" height=\"135\"><\/figure><\/div><p> Bundan sonra INDEX bu konum numaras\u0131n\u0131 MACTH&#8217;den al\u0131r ve <sup>4.<\/sup> konumdaki aral\u0131k de\u011ferini al\u0131r. Bu A5 h\u00fccresi anlam\u0131na gelir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80567\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Lindex-9-prend-la-position-apres-le-match.png\" sizes=\"auto, \" srcset=\"\" alt=\"indeks-ma\u00e7tan sonra-pozisyon al\u0131r\" width=\"341\" height=\"122\"><\/figure><\/div><div class=\"wp-block-group grey-note is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><p> <strong>SECRET<\/strong> : INDEX yukar\u0131daki \u00f6rnekte aral\u0131\u011f\u0131n 4. konumunun veya A5 h\u00fccresinin de\u011ferini d\u00f6nd\u00fcr\u00fcr. Ancak INDEX bir i\u015flev olarak iki farkl\u0131 de\u011fer d\u00f6nd\u00fcr\u00fcr. Biri h\u00fccre de\u011feridir (yukar\u0131da g\u00f6rebilirsiniz), ikincisi ise de\u011ferin sakland\u0131\u011f\u0131 h\u00fccrenin adresidir (A5). Kullan\u0131c\u0131 olarak h\u00fccre adresini g\u00f6remezsiniz veya alamazs\u0131n\u0131z, ancak CELL i\u015flevi onu al\u0131p kullanacak kadar ak\u0131ll\u0131d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80568\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-index-renvoie-la-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"indeks-d\u00f6n\u00fc\u015f-de\u011feri\" width=\"731\" height=\"160\"><\/figure><\/div><\/div><\/div><p> Sonu\u00e7ta CELL i\u015flevi, sonu\u00e7taki mutlak bir referans\u0131 kullanarak h\u00fccrenin adresini d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80569\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-fonction-de-cellule-renvoie-ladresse-de-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccre-i\u015flevi-d\u00f6nd\u00fcr\u00fcr-h\u00fccre-adresi\" width=\"639\" height=\"257\"><\/figure><\/div><p> H\u00fccre adresinden dolar i\u015faretini kald\u0131rmak istiyorsan\u0131z SUBSTITUTE&#8217;u kullanabilirsiniz. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBSTITUTE(CELL(\"address\",INDEX(A2:A1001,MATCH(C1,A2:A1001,0))),\"$\",\"\")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80570\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-supprimer-le-signe-dollar-par-substitut.png\" sizes=\"auto, \" srcset=\"\" alt=\"ikame-dolar-i\u015faretini-kald\u0131r\" width=\"763\" height=\"229\"><\/figure><\/div><h2 class=\"wp-block-heading\"> ADDRESS + MATCH kullanarak h\u00fccre adresini al\u0131n<\/h2><p> H\u00fccre adresini almak i\u00e7in form\u00fcl yazman\u0131n ba\u015fka bir yolu daha var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80571\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-adresse-de-cellule-par-adresse-plus-correspondance.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccre adresi-adres-art\u0131-e\u015fle\u015fme\" width=\"749\" height=\"251\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=ADDRESS(MATCH(C1,A1:A1001,0),1)<\/code><\/pre><p> Bu form\u00fcl iki b\u00f6l\u00fcmde \u00e7al\u0131\u015f\u0131r: \u0130lk b\u00f6l\u00fcmde, arama de\u011ferinin bulundu\u011fu h\u00fccrenin konum numaras\u0131n\u0131 almak i\u00e7in MATCH fonksiyonumuz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80572\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-match-obtient-le-numero-de-position-de-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"ma\u00e7-al\u0131r-pozisyon-h\u00fccre-numaras\u0131n\u0131 al\u0131r\" width=\"527\" height=\"123\"><\/figure><\/div><p> Bundan sonra, ADRES i\u015flevinde, sat\u0131r numaras\u0131n\u0131 ayarlamak i\u00e7in SATIR ba\u011f\u0131ms\u0131z de\u011fi\u015fkeni olan MATCH taraf\u0131ndan d\u00f6nd\u00fcr\u00fclen say\u0131ya (ilk ba\u011f\u0131ms\u0131z de\u011fi\u015fkende) sahip olursunuz.<\/p><p> \u0130kinci arg\u00fcmanda ise s\u00fctun numaras\u0131 var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80573\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-fonction-dadresse-ont-un-numero-renvoye-par-correspondance.png\" sizes=\"auto, \" srcset=\"\" alt=\"adres-i\u015flev-numaras\u0131-e\u015fle\u015fmeye g\u00f6re-d\u00f6n\u00fc\u015f\" width=\"433\" height=\"115\"><\/figure><\/div><p> Sat\u0131r 5 ve s\u00fctun 1, A5 h\u00fccre adresini olu\u015fturur.<\/p><p> <strong>Tavsiye: <sup>1.<\/sup> y\u00f6ntem<\/strong> <\/p><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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/rechercher-ladresse-de-la-cellule.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/p><\/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\/birden-fazla-kritere-goz-atma\/\">Excel&#8217;de birden fazla \u00f6l\u00e7\u00fctle D\u00dc\u015eEYARA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vlookup-ozellikli-joker-karakterler\/\">Excel&#8217;de D\u00dc\u015eEYARA i\u00e7eren joker karakterler<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-arama-v\/\">D\u00dc\u015eEYARA Tarihleri (verilerden bir tarih i\u00e7in D\u00dc\u015eEYARA)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/son-degeri-bul-2\/\">Bir s\u00fctun veya sat\u0131rdaki son de\u011feri bulma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/baska-bir-sayfadan-vlookup\/\">Ba\u015fka bir sayfadan D\u00dc\u015eEYARA (sayfalar aras\u0131nda)<\/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-1780","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>De\u011fer yerine h\u00fccre adresini bulma<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim size, de\u011fer yerine h\u00fccre adresini bulmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. 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\/2-hucrenin-adresini-bul\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"De\u011fer yerine h\u00fccre adresini bulma\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim size, de\u011fer yerine h\u00fccre adresini bulmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-ladresse-cellulaire.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\/2-hucrenin-adresini-bul\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/\",\"name\":\"De\u011fer yerine h\u00fccre adresini bulma\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-ladresse-cellulaire.png\",\"datePublished\":\"2023-11-05T07:22:56+00:00\",\"dateModified\":\"2023-12-10T05:59:16+00:00\",\"description\":\"Bu e\u011fitim size, de\u011fer yerine h\u00fccre adresini bulmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-ladresse-cellulaire.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-ladresse-cellulaire.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"De\u011fer yerine h\u00fccre adresini bulma\"}]},{\"@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":"De\u011fer yerine h\u00fccre adresini bulma","description":"Bu e\u011fitim size, de\u011fer yerine h\u00fccre adresini bulmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. 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\/2-hucrenin-adresini-bul\/","og_locale":"tr_TR","og_type":"article","og_title":"De\u011fer yerine h\u00fccre adresini bulma","og_description":"Bu e\u011fitim size, de\u011fer yerine h\u00fccre adresini bulmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","og_url":"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:16+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-ladresse-cellulaire.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\/2-hucrenin-adresini-bul\/","url":"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/","name":"De\u011fer yerine h\u00fccre adresini bulma","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-ladresse-cellulaire.png","datePublished":"2023-11-05T07:22:56+00:00","dateModified":"2023-12-10T05:59:16+00:00","description":"Bu e\u011fitim size, de\u011fer yerine h\u00fccre adresini bulmak i\u00e7in bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-ladresse-cellulaire.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-ladresse-cellulaire.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/2-hucrenin-adresini-bul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"De\u011fer yerine h\u00fccre adresini bulma"}]},{"@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\/1780","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=1780"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1780\/revisions"}],"predecessor-version":[{"id":2309,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1780\/revisions\/2309"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}