{"id":15575,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kaydir\/"},"modified":"2021-02-25T16:33:16","modified_gmt":"2021-02-25T16:33:16","slug":"offset","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/offset\/","title":{"rendered":"KAYDIR"},"content":{"rendered":"

Kayd\u0131r Fonksiyonunun Temelleri<\/h2>\n

KAYDIR (OFFSET) fonksiyonu, hem Excel hem de Google E-Tablolar\u2019da olduk\u00e7a g\u00fc\u00e7l\u00fc ve esnek bir ara\u00e7t\u0131r. Bu fonksiyon, bir ba\u015flang\u0131\u00e7 h\u00fccresi referans\u0131ndan belirli bir konuma kayd\u0131rarak yeni bir h\u00fccre veya h\u00fccre aral\u0131\u011f\u0131 referans\u0131 olu\u015fturman\u0131za olanak tan\u0131r. Kullan\u0131c\u0131lar\u0131n dinamik hesaplamalar yapmas\u0131n\u0131 ve \u00e7e\u015fitli senaryolarda veri manip\u00fclasyonu ger\u00e7ekle\u015ftirmesini sa\u011flar.<\/p>\n

  =KAYDIR(ref, sat\u0131rlar, s\u00fctunlar, [y\u00fckseklik], [geni\u015flik]) <\/code> <\/pre>\n
    \n
  • ref<\/strong>: Ba\u015flang\u0131\u00e7 noktas\u0131 olarak kullan\u0131lacak h\u00fccre veya h\u00fccre aral\u0131\u011f\u0131n\u0131 belirler.<\/li>\n
  • sat\u0131rlar<\/strong>: Ref noktas\u0131ndan ka\u00e7 sat\u0131r yukar\u0131 veya a\u015fa\u011f\u0131 kayd\u0131r\u0131laca\u011f\u0131n\u0131 belirtir. Negatif de\u011ferler yukar\u0131, pozitif de\u011ferler a\u015fa\u011f\u0131 kayd\u0131rma yapar.<\/li>\n
  • s\u00fctunlar<\/strong>: Ref noktas\u0131ndan ka\u00e7 s\u00fctun sola veya sa\u011fa kayd\u0131r\u0131laca\u011f\u0131n\u0131 belirtir. Negatif de\u011ferler sola, pozitif de\u011ferler sa\u011fa kayd\u0131rma yapar.<\/li>\n
  • y\u00fckseklik<\/strong>: (\u0130ste\u011fe ba\u011fl\u0131) Olu\u015fturulan yeni h\u00fccre aral\u0131\u011f\u0131n\u0131n sat\u0131r say\u0131s\u0131n\u0131 belirler.<\/li>\n
  • geni\u015flik<\/strong>: (\u0130ste\u011fe ba\u011fl\u0131) Olu\u015fturulan yeni h\u00fccre aral\u0131\u011f\u0131n\u0131n s\u00fctun say\u0131s\u0131n\u0131 belirler.<\/li>\n<\/ul>\n
    \u00c7al\u0131\u015fma Senaryolar\u0131 ve Uygulama<\/h2>\n
    Zaman Serisi Verilerde Kayd\u0131rma<\/h3>\n
    \u00d6zellikle finansal analizlerde son X d\u00f6nemine ait verileri g\u00f6zlemlemek i\u00e7in KAYDIR fonksiyonunu kullanabilirsiniz. \u00d6rne\u011fin, bir stokun ge\u00e7mi\u015f 5 g\u00fcnl\u00fck kapan\u0131\u015f fiyatlar\u0131n\u0131n ortalamas\u0131n\u0131 bulmak isteyin:<\/p>\n
      =AVERAGE(KAYDIR(A1, -4, 0, 5)) <\/code> <\/pre>\n
    Bu form\u00fcl, A1 h\u00fccresini referans alarak 4 sat\u0131r yukar\u0131 gidip, yukar\u0131daki 5 h\u00fccreyi (A1 dahil) se\u00e7er ve bu h\u00fccrelerin ortalamas\u0131n\u0131 hesaplar.<\/p>\n
    B\u00fct\u00e7e Tablolar\u0131nda Dinamik Referanslama<\/h3>\n
    KAYDIR fonksiyonu, b\u00fct\u00e7e tablolar\u0131 gibi s\u00fcrekli g\u00fcncellenen ve geni\u015fleyen veri setlerinde \u00f6zellikle i\u015fe yarar. Diyelim ki, her ay i\u00e7in ayr\u0131 bir s\u00fctununuz var ve en son aylar\u0131n b\u00fct\u00e7e verilerini dinamik olarak referans almak istiyorsunuz:<\/p>\n
      =SUM(KAYDIR(A1, 0, COUNTA(A1:Z1) - 1, 1, 3)) <\/code> <\/pre>\n
    Bu form\u00fcl, A1 h\u00fccresinden ba\u015flayarak, A\u2019dan Z\u2019ye s\u00fctunlardaki dolu h\u00fccre say\u0131s\u0131n\u0131 hesaplar ve en son \u00fc\u00e7 ay\u0131n toplam\u0131n\u0131 al\u0131r. COUNTA(A1:Z1) – 1, dolu h\u00fccre say\u0131s\u0131 kadar sa\u011fa kayd\u0131rarak en son dolu h\u00fccreyi bulur ve oradan son \u00fc\u00e7 s\u00fctunu se\u00e7er.<\/p>\n
    \u0130pu\u00e7lar\u0131 ve S\u0131k Yap\u0131lan Hatalar<\/h2>\n
    KAYDIR fonksiyonunu kullan\u0131rken dikkat edilmesi gereken birka\u00e7 \u00f6nemli nokta vard\u0131r:<\/p>\n
      \n
    • KAYDIR fonksiyonunun s\u0131k\u00e7a yol a\u00e7t\u0131\u011f\u0131 hatalardan biri, referans al\u0131nan h\u00fccrelerin d\u0131\u015f\u0131na ta\u015fma ihtimalidir. Bu, \u00e7o\u011funlukla yanl\u0131\u015f sat\u0131r veya s\u00fctun say\u0131lar\u0131n\u0131n girilmesiyle olu\u015fur.<\/li>\n
    • Performans sorunlar\u0131: KAYDIR fonksiyonu, \u00f6zellikle b\u00fcy\u00fck veri setlerinde ve dizilerde \u00e7ok say\u0131da kullan\u0131ld\u0131\u011f\u0131nda hesaplama s\u00fcresini art\u0131rabilir. Bu y\u00fczden, fonksiyonun kullan\u0131m\u0131n\u0131 s\u0131n\u0131rlamak veya alternatif y\u00f6ntemler d\u00fc\u015f\u00fcnmek bazen daha iyidir.<\/li>\n<\/ul>\n
      Excel ve Google E-Tablolar ile \u00e7al\u0131\u015f\u0131rken KAYDIR fonksiyonu, veri setlerinizle dinamik ve esnek bir \u015fekilde \u00e7al\u0131\u015fman\u0131z\u0131 sa\u011flar. Ancak, fonksiyonun syntax ve davran\u0131\u015flar\u0131n\u0131 iyi anlamak ve gerekti\u011finde alternatif y\u00f6ntemlere ba\u015fvurmak \u00f6nemlidir.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Verilen bir ba\u015fvurudan, bir ba\u015fvuru kayd\u0131rmay\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[579],"tags":[],"class_list":["post-15575","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nExcel'de OFFSET (KAYDIR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da OFFSET (KAYDIR) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/offset\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de OFFSET (KAYDIR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da OFFSET (KAYDIR) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/offset\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:33:16+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de OFFSET (KAYDIR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/offset\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/offset\/\",\"name\":\"Excel'de OFFSET (KAYDIR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:33:16+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da OFFSET (KAYDIR) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/offset\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/offset\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/offset\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Arama ve ba\u015fvuru\",\"item\":\"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"KAYDIR\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de OFFSET (KAYDIR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da OFFSET (KAYDIR) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/offset\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de OFFSET (KAYDIR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da OFFSET (KAYDIR) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/offset\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:33:16+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de OFFSET (KAYDIR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/offset\/","url":"https:\/\/functiontranslator.com\/tr\/offset\/","name":"Excel'de OFFSET (KAYDIR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:33:16+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da OFFSET (KAYDIR) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/offset\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/offset\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/offset\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Arama ve ba\u015fvuru","item":"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/"},{"@type":"ListItem","position":3,"name":"KAYDIR"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15575"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15575\/revisions"}],"predecessor-version":[{"id":26843,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15575\/revisions\/26843"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}