{"id":15542,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/encok_olan-tek\/"},"modified":"2021-02-25T16:32:06","modified_gmt":"2021-02-25T16:32:06","slug":"mode-sngl","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/mode-sngl\/","title":{"rendered":"EN\u00c7OK_OLAN.TEK"},"content":{"rendered":"

MODE.SNGL<\/strong> veya T\u00fcrk\u00e7e ad\u0131yla EN\u00c7OK_OLAN.TEK<\/strong> fonksiyonu, bir veri setinde en s\u0131k rastlanan de\u011feri (mod) teslim eder. Veri serisinde birden fazla mod de\u011feri varsa, MODE.SNGL bu de\u011ferler aras\u0131ndan yaln\u0131zca ilkini d\u00f6nd\u00fcr\u00fcr. Google Sheets ile uyumlu \u00e7al\u0131\u015fan bu fonksiyon, burada sadece MODE olarak bilinir ve benzer i\u015flevsellik g\u00f6sterir.<\/p>\n

MODE.SNGL S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

Excel ve Google Sheets’te MODE.SNGL fonksiyonunun s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=EN\u00c7OK_OLAN.TEK(say\u01311, [say\u01312], ...)<\/code><\/pre>\n
    \n
  • say\u01311:<\/strong> Mod de\u011ferini bulmak istedi\u011finiz ilk say\u0131 veya h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • say\u01312, … (opsiyonel):<\/strong> \u0130kinci, \u00fc\u00e7\u00fcnc\u00fc vb. ek say\u0131lar ya da h\u00fccre aral\u0131klar\u0131. Bu parametreler iste\u011fe ba\u011fl\u0131d\u0131r ve analiz edilmek \u00fczere ek veri sa\u011flarlar.<\/li>\n<\/ul>\n
    \u00d6rnek:<\/p>\n
    =EN\u00c7OK_OLAN.TEK(A1:A10)<\/code><\/pre>\n
    Bu form\u00fcl, A1:A10 aral\u0131\u011f\u0131ndaki h\u00fccreler i\u00e7inde en s\u0131k rastlanan de\u011feri bulur.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    Ders Notlar\u0131nda Mod Bulma<\/h2>\n
    \u00d6\u011fretmenler, \u00f6\u011frencilerin s\u0131nav sonu\u00e7lar\u0131nda en s\u0131k g\u00f6r\u00fclen notu belirlemek i\u00e7in MODE.SNGL fonksiyonundan yararlanabilirler. Bu, hangi notun s\u0131n\u0131f genelinde en yayg\u0131n oldu\u011funu g\u00f6rmek i\u00e7in kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n
    \u00d6rne\u011fin, \u00f6\u011frenci s\u0131nav sonu\u00e7lar\u0131 A2:A21 aral\u0131\u011f\u0131nda yer al\u0131yorsa, kullan\u0131lacak form\u00fcl \u015f\u00f6yle olur:<\/p>\n
    =EN\u00c7OK_OLAN.TEK(A2:A21)<\/code><\/pre>\n
    Bu, en s\u0131k rastlanan notu verir.<\/p>\n
    \u00dcr\u00fcn Sat\u0131\u015f Analizi<\/h2>\n
    Sat\u0131\u015f departmanlar\u0131, en \u00e7ok sat\u0131lan \u00fcr\u00fcnleri tespit etmek i\u00e7in MODE.SNGL fonksiyonunu kullanabilir. Bu bilgi, stok y\u00f6netimi ve pazarlama stratejilerini planlama a\u00e7\u0131s\u0131ndan de\u011ferlidir.<\/p>\n
    E\u011fer sat\u0131\u015f verileri B1:B100 aras\u0131nda ise, kullan\u0131lacak form\u00fcl bu olacakt\u0131r:<\/p>\n
    =EN\u00c7OK_OLAN.TEK(B1:B100)<\/code><\/pre>\n
    Bu form\u00fcl, hangi \u00fcr\u00fcn\u00fcn en \u00e7ok sat\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/p>\n
    Bu iki \u00f6rnekle, MODE.SNGL fonksiyonunun e\u011fitim ve i\u015f d\u00fcnyas\u0131nda nas\u0131l kullan\u0131labilece\u011fini a\u00e7\u0131k\u00e7a g\u00f6rmekteyiz. Bu fonksiyon, veri setlerinden \u00f6nemli bilgiler elde etmek amac\u0131yla etkili ve kullan\u0131\u015fl\u0131 bir ara\u00e7t\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Veri k\u00fcmesindeki en s\u0131k kar\u015f\u0131la\u015f\u0131lan de\u011feri verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[582],"tags":[],"class_list":["post-15542","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de MODE.SNGL (EN\u00c7OK_OLAN.TEK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da MODE.SNGL (EN\u00c7OK_OLAN.TEK) 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\/mode-sngl\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de MODE.SNGL (EN\u00c7OK_OLAN.TEK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da MODE.SNGL (EN\u00c7OK_OLAN.TEK) 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\/mode-sngl\/\" \/>\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:32:06+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 MODE.SNGL (EN\u00c7OK_OLAN.TEK) 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=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/mode-sngl\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/mode-sngl\/\",\"name\":\"Excel'de MODE.SNGL (EN\u00c7OK_OLAN.TEK) 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:32:06+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da MODE.SNGL (EN\u00c7OK_OLAN.TEK) 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\/mode-sngl\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/mode-sngl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/mode-sngl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0130statistik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/istatistik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"EN\u00c7OK_OLAN.TEK\"}]},{\"@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 MODE.SNGL (EN\u00c7OK_OLAN.TEK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da MODE.SNGL (EN\u00c7OK_OLAN.TEK) 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\/mode-sngl\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de MODE.SNGL (EN\u00c7OK_OLAN.TEK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da MODE.SNGL (EN\u00c7OK_OLAN.TEK) 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\/mode-sngl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:32:06+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de MODE.SNGL (EN\u00c7OK_OLAN.TEK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/mode-sngl\/","url":"https:\/\/functiontranslator.com\/tr\/mode-sngl\/","name":"Excel'de MODE.SNGL (EN\u00c7OK_OLAN.TEK) 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:32:06+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da MODE.SNGL (EN\u00c7OK_OLAN.TEK) 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\/mode-sngl\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/mode-sngl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/mode-sngl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"\u0130statistik","item":"https:\/\/functiontranslator.com\/tr\/istatistik\/"},{"@type":"ListItem","position":3,"name":"EN\u00c7OK_OLAN.TEK"}]},{"@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\/15542","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=15542"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15542\/revisions"}],"predecessor-version":[{"id":26810,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15542\/revisions\/26810"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}