{"id":15312,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/sutun\/"},"modified":"2021-02-25T16:23:42","modified_gmt":"2021-02-25T16:23:42","slug":"column","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/column\/","title":{"rendered":"S\u00dcTUN"},"content":{"rendered":"<p>Microsoft Excel ve Google E-Tablolar, veri analizi ve bilgi i\u015flemde vazge\u00e7ilmez ara\u00e7lard\u0131r. Her iki platformda da kullan\u0131lan <strong>COLUMN<\/strong> (S\u00dcTUN) i\u015flevi, belirli bir h\u00fccrenin veya h\u00fccre aral\u0131\u011f\u0131n\u0131n s\u00fctun numaras\u0131n\u0131 d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. Bu i\u015flev, \u00f6zellikle b\u00fcy\u00fck veri setleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken veya dinamik form\u00fcller haz\u0131rlarken kullan\u0131\u015fl\u0131d\u0131r. Bu makalede, COLUMN i\u015flevinin s\u00f6zdizimi ve pratik kullan\u0131m\u0131 \u00fczerine yo\u011funla\u015faca\u011f\u0131z.<\/p>\n<h2>S\u00f6zdizimi ve Temel Kullan\u0131m<\/h2>\n<p><code>COLUMN<\/code> i\u015flevinin temel s\u00f6zdizimi son derece basittir ve \u015fu \u015fekildedir:<\/p>\n<pre><code>=COLUMN([h\u00fccre_referans\u0131])<\/code><\/pre>\n<p>Burada &#8220;h\u00fccre_referans\u0131&#8221; iste\u011fe ba\u011fl\u0131d\u0131r. E\u011fer bu arg\u00fcman bo\u015f b\u0131rak\u0131l\u0131rsa, form\u00fcl\u00fcn yaz\u0131ld\u0131\u011f\u0131 h\u00fccrenin s\u00fctun numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. E\u011fer bir h\u00fccre referans\u0131 verilirse, verilen h\u00fccrenin s\u00fctun numaras\u0131n\u0131 verir.<\/p>\n<h2>Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmleri<\/h2>\n<p>Bu b\u00f6l\u00fcmde, COLUMN i\u015flevinin i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131 nas\u0131l kolayla\u015ft\u0131rabilece\u011fini g\u00f6steren iki pratik \u00f6rnek sunaca\u011f\u0131z.<\/p>\n<h3>1. Dinamik Ba\u015fl\u0131k E\u015fle\u015ftirmesi<\/h3>\n<p>Veri tablolar\u0131n\u0131zda s\u0131kl\u0131kla ba\u015fl\u0131k s\u00fctunlar\u0131n\u0131 kod i\u00e7inde referans alman\u0131z gerekebilir. COLUMN i\u015flevi, ba\u015fl\u0131k s\u00fctununun dinamik olarak tan\u0131mlanmas\u0131n\u0131 sa\u011flar, b\u00f6ylece s\u00fctun ba\u015fl\u0131klar\u0131 de\u011fi\u015fse bile form\u00fclleriniz hatas\u0131z \u00e7al\u0131\u015fmaya devam eder.<\/p>\n<pre><code>\u00d6rnek datam\u0131z \u015fu \u015fekilde olsun: A s\u00fctunu \"ID\", B s\u00fctunu \"Ad\", C s\u00fctunu \"Soyad\". E\u011fer \"Ad\" s\u00fctununun numaras\u0131n\u0131 bulmak istiyorsak, \u015fu form\u00fcl\u00fc kullanabiliriz: =COLUMN(B1) \/\/ Sonu\u00e7: 2 <\/code><\/pre>\n<p>Bu form\u00fcl, &#8220;Ad&#8221; ba\u015fl\u0131\u011f\u0131n\u0131n B s\u00fctununda oldu\u011funu do\u011frulad\u0131\u011f\u0131n\u0131zda form\u00fcl otomatik olarak 2 de\u011ferini d\u00f6nd\u00fcrecektir.<\/p>\n<h3>2. \u0130statistiksel Analizlerde Kolay Referans<\/h3>\n<p>\u0130statistiksel analizler yaparken, s\u0131kl\u0131kla belirli s\u00fctunlar\u0131 temel alarak hesaplamalar yap\u0131l\u0131r. COLUMN i\u015flevi, bu t\u00fcr dinamik hesaplamalar\u0131 yaparken s\u00fctun referans\u0131n\u0131 otomatik hale getirebilir.<\/p>\n<pre><code>Varsayal\u0131m ki data setiniz A1:C100 aral\u0131\u011f\u0131na yay\u0131lmakta ve C s\u00fctunu maa\u015f bilgilerini i\u00e7ermekte. Maa\u015flar s\u00fctununu referans alarak ortalama bir hesaplama yapmak isteyin: =SUM(C1:C100)\/COUNTA(C1:C100) \/\/ortalama maa\u015f Bu form\u00fclde, \"C1:C100\" aral\u0131\u011f\u0131 \"y\u00fckseklik\" s\u00fctunu i\u00e7in hard-coded bir referanst\u0131r. <\/code><\/pre>\n<p>E\u011fer &#8220;Maa\u015f&#8221; s\u00fctunu konumu de\u011fi\u015firse, bu form\u00fcl hatal\u0131 sonu\u00e7lar \u00fcretebilir. COLUMN i\u015flevini kullanarak daha dinamik bir yap\u0131 kurabiliriz:<\/p>\n<pre><code>Let's say COLUMN yerine s\u00fctun ba\u015fl\u0131\u011f\u0131 \"Maa\u015f\" olsun ve B s\u00fctununda yer als\u0131n: =SUM(INDIRECT(\"B1:B\" &amp; COUNTA(B:B)))\/COUNTA(INDIRECT(\"B1:B\" &amp; COUNTA(B:B))) Bu yap\u0131, s\u00fctunun yer de\u011fi\u015ftirmesi durumunda dahi do\u011fru sonuclar\u0131 \u00fcretmeye devam eder. <\/code><\/pre>\n<p>COLUMN i\u015flevi, Excel ve Google E-Tablolar&#8217;da etkili ve esnek veri i\u015fleme yetene\u011fi kazand\u0131r\u0131r. S\u00fctun numaralar\u0131n\u0131 dinamik olarak y\u00f6netmek isteyen her seviyeden kullan\u0131c\u0131 i\u00e7in kullan\u0131\u015fl\u0131 bir ara\u00e7t\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ba\u015fvurunun s\u00fctun numaras\u0131n\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-15312","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de COLUMN (S\u00dcTUN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da COLUMN (S\u00dcTUN) 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\/column\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de COLUMN (S\u00dcTUN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da COLUMN (S\u00dcTUN) 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\/column\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:23:42+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de COLUMN (S\u00dcTUN) 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\/column\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/column\/\",\"name\":\"Excel'de COLUMN (S\u00dcTUN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:23:42+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COLUMN (S\u00dcTUN) 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\/column\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/column\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/column\/#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\":\"S\u00dcTUN\"}]},{\"@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 COLUMN (S\u00dcTUN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COLUMN (S\u00dcTUN) 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\/column\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COLUMN (S\u00dcTUN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COLUMN (S\u00dcTUN) 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\/column\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:23:42+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COLUMN (S\u00dcTUN) 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\/column\/","url":"https:\/\/functiontranslator.com\/tr\/column\/","name":"Excel'de COLUMN (S\u00dcTUN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:23:42+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COLUMN (S\u00dcTUN) 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\/column\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/column\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/column\/#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":"S\u00dcTUN"}]},{"@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\/15312","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=15312"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15312\/revisions"}],"predecessor-version":[{"id":26580,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15312\/revisions\/26580"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}