{"id":15508,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/buyuk\/"},"modified":"2021-02-25T16:30:29","modified_gmt":"2021-02-25T16:30:29","slug":"large","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/large\/","title":{"rendered":"B\u00dcY\u00dcK"},"content":{"rendered":"

Say\u0131sal Verilerde Belirli S\u0131radaki En B\u00fcy\u00fck De\u011feri Bulma<\/h2>\n

Hem Microsoft Excel hem de Google E-Tablolar, veri analizi i\u015flemlerinde yard\u0131mc\u0131 olan bir\u00e7ok i\u015flev sunar. Bu i\u015flevlerden biri de “LARGE” ya da T\u00fcrk\u00e7e ad\u0131yla “B\u00dcY\u00dcK” i\u015flevidir. Bu i\u015flev, veri setindeki en b\u00fcy\u00fck n’inci de\u011feri d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. Bu rehberde, “B\u00dcY\u00dcK” i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenecek ve iki g\u00fcnl\u00fck pratik \u00f6rne\u011fi ele alaca\u011f\u0131z. <\/p>\n

\u0130\u015flevin S\u00f6zdizimi ve \u00d6zellikleri<\/h2>\n

“B\u00dcY\u00dcK” i\u015flevi a\u015fa\u011f\u0131daki gibi kullan\u0131l\u0131r:<\/p>\n

  B\u00dcY\u00dcK(dizi; n) <\/code> <\/pre>\n
 Burada dizi<\/code>, i\u015flemin uyguland\u0131\u011f\u0131 say\u0131sal verilerin yer ald\u0131\u011f\u0131 dizi veya aral\u0131kt\u0131r. n<\/code> ise geri d\u00f6nd\u00fcrmek istedi\u011finiz en b\u00fcy\u00fck de\u011ferin s\u0131ralamas\u0131d\u0131r. \u00d6rne\u011fin, n=1 en b\u00fcy\u00fck de\u011feri, n=2 ikinci en b\u00fcy\u00fck de\u011feri getirir. <\/p>\n
\u0130\u015flevin Kullan\u0131m\u0131 \u0130le \u0130ki Pratik \u00d6rnek<\/h2>\n
A\u015fa\u011f\u0131da “B\u00dcY\u00dcK” i\u015flevinin kullan\u0131m\u0131n\u0131 a\u00e7\u0131klayan iki farkl\u0131 senaryo bulunmaktad\u0131r:<\/p>\n
    \n
  •  Sat\u0131\u015f Verilerinde Maksimum Sat\u0131\u015flar\u0131 Analiz Etme:<\/strong> Bir \u015firketin ayl\u0131k sat\u0131\u015f verileri \u00fczerinde \u00e7al\u0131\u015f\u0131yoruz ve en y\u00fcksek be\u015f sat\u0131\u015f de\u011ferini belirlemek istiyoruz. <\/li>\n<\/ul>\n
    \u00d6rnek form\u00fcl:<\/p>\n
      =B\u00dcY\u00dcK(A2:A100; 1) \/\/ En y\u00fcksek sat\u0131\u015f =B\u00dcY\u00dcK(A2:A100; 2) \/\/ \u0130kinci en y\u00fcksek sat\u0131\u015f =B\u00dcY\u00dcK(A2:A100; 3) \/\/ \u00dc\u00e7\u00fcnc\u00fc en y\u00fcksek sat\u0131\u015f <\/code> <\/pre>\n
    Bu form\u00fcller, s\u0131ras\u0131yla dizideki en y\u00fcksek, ikinci ve \u00fc\u00e7\u00fcnc\u00fc en y\u00fcksek sat\u0131\u015flar\u0131 bulur.<\/p>\n
      \n
    •  E\u011fitim Puanlar\u0131 \u00dczerinden \u00d6\u011frenci Performans\u0131 S\u0131ralamas\u0131:<\/strong> Bir s\u0131n\u0131f\u0131n s\u0131nav sonu\u00e7lar\u0131n\u0131 i\u00e7eren bir listede, en y\u00fcksek ve alttan \u00fc\u00e7\u00fcnc\u00fc en y\u00fcksek puanlar\u0131 belirlemek istiyoruz. <\/li>\n<\/ul>\n
      \u00d6rnek form\u00fcl:<\/p>\n
        =B\u00dcY\u00dcK(B2:B50; 1) \/\/ En y\u00fcksek puan =B\u00dcY\u00dcK(B2:B50; 3) \/\/ \u00dc\u00e7\u00fcnc\u00fc en y\u00fcksek puan <\/code> <\/pre>\n
      Bu form\u00fcller sayesinde, e\u011fitmenler \u00f6\u011frencilerin s\u0131nav performanslar\u0131n\u0131 h\u0131zl\u0131ca analiz edebilir ve ba\u015far\u0131 s\u0131ralamalar\u0131n\u0131 kolayca yapabilirler.<\/p>\n
      Sonu\u00e7 ve Yorumlar<\/h2>\n
       “B\u00dcY\u00dcK” i\u015flevi, b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7erisinden belirli bir s\u0131radaki en b\u00fcy\u00fck de\u011ferleri h\u0131zl\u0131ca \u00e7ekmek i\u00e7in son derece kullan\u0131\u015fl\u0131d\u0131r. Bu i\u015flev sayesinde, b\u00fcy\u00fck veri setleri \u00fczerinde performans analizi, sat\u0131\u015f trendlerinin belirlenmesi veya akademik ba\u015far\u0131 s\u0131ralamalar\u0131 gibi bir\u00e7ok alanda pratik ve h\u0131zl\u0131 sonu\u00e7lar elde etmek m\u00fcmk\u00fcnd\u00fcr. Excel ve Google E-Tablolar, bu t\u00fcr i\u015flevlerle veri analizini her seviyeden kullan\u0131c\u0131ya daha eri\u015filebilir k\u0131lar. <\/p>\n","protected":false},"excerpt":{"rendered":"
      Veri k\u00fcmesindeki k en b\u00fcy\u00fck 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-15508","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de LARGE (B\u00dcY\u00dcK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da LARGE (B\u00dcY\u00dcK) 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\/large\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de LARGE (B\u00dcY\u00dcK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da LARGE (B\u00dcY\u00dcK) 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\/large\/\" \/>\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:30:29+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 LARGE (B\u00dcY\u00dcK) 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\/large\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/large\/\",\"name\":\"Excel'de LARGE (B\u00dcY\u00dcK) 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:30:29+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da LARGE (B\u00dcY\u00dcK) 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\/large\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/large\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/large\/#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\":\"B\u00dcY\u00dcK\"}]},{\"@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 LARGE (B\u00dcY\u00dcK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da LARGE (B\u00dcY\u00dcK) 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\/large\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de LARGE (B\u00dcY\u00dcK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da LARGE (B\u00dcY\u00dcK) 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\/large\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:30:29+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de LARGE (B\u00dcY\u00dcK) 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\/large\/","url":"https:\/\/functiontranslator.com\/tr\/large\/","name":"Excel'de LARGE (B\u00dcY\u00dcK) 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:30:29+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da LARGE (B\u00dcY\u00dcK) 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\/large\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/large\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/large\/#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":"B\u00dcY\u00dcK"}]},{"@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\/15508","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=15508"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15508\/revisions"}],"predecessor-version":[{"id":27056,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15508\/revisions\/27056"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}