{"id":15582,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/yuzderank-hrc\/"},"modified":"2021-02-25T16:33:25","modified_gmt":"2021-02-25T16:33:25","slug":"percentrank-exc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/percentrank-exc\/","title":{"rendered":"Y\u00dcZDERANK.HRC"},"content":{"rendered":"

Syntax ve Genel Bak\u0131\u015f<\/h2>\n

Y\u00dcZDERANK.HRC fonksiyonu, bir de\u011ferin veri k\u00fcmesi i\u00e7erisindeki y\u00fczdelik derecesini, en d\u00fc\u015f\u00fck de\u011ferden en y\u00fckse\u011fe do\u011fru olan konumunu belirlemek i\u00e7in kullan\u0131l\u0131r. Fonksiyon, veri k\u00fcmesindeki mevcut de\u011ferleri hari\u00e7 tutarak, aranan de\u011ferin y\u00fczdelik derecesini d\u00f6nd\u00fcr\u00fcr.<\/p>\n

  Y\u00dcZDERANK.HRC(aranan_veri; veri_k\u00fcmesi; [basamak]) <\/code> <\/pre>\n
    \n
  • aranan_veri<\/b>: Y\u00fczdelik derece hesaplanacak de\u011fer.<\/li>\n
  • veri_k\u00fcmesi<\/b>: Y\u00fczdelik derece hesaplamas\u0131nda kar\u015f\u0131la\u015ft\u0131rma yap\u0131lacak veri k\u00fcmesi.<\/li>\n
  • basamak<\/b> (opsiyonel): Y\u00fczdelik derecenin ka\u00e7 ondal\u0131k basamakla g\u00f6sterilece\u011fini belirler. Varsay\u0131lan de\u011fer 3’t\u00fcr.<\/li>\n<\/ul>\n
    \u00d6rnek Kullan\u0131m<\/h2>\n
    S\u0131nav sonu\u00e7lar\u0131 \u00fczerinden \u00f6\u011frencilerin performans s\u0131ralamas\u0131n\u0131 hesaplamak i\u00e7in Y\u00dcZDERANK.HRC fonksiyonunun kullan\u0131m\u0131:<\/p>\n
      Veri K\u00fcmesi: 55, 89, 76, 65, 95, 68 Aranan Veri: 76 Form\u00fcl: Y\u00dcZDERANK.HRC(76; A1:A6) Sonu\u00e7: 0.6 <\/code> <\/pre>\n
    Bu \u00f6rnekte, 76 puan alan \u00f6\u011frenci, t\u00fcm notlar aras\u0131nda y\u00fczdelik olarak %60 diliminde yer almaktad\u0131r.<\/p>\n
    Uygulamal\u0131 \u00d6rnekler<\/h2>\n
    1. Sat\u0131\u015f Performans\u0131 De\u011ferlendirmesi:<\/b><\/p>\n
    Sat\u0131\u015f temsilcilerinin toplam sat\u0131\u015flara g\u00f6re performans\u0131n\u0131n y\u00fczdelik s\u0131ralamas\u0131n\u0131 hesaplamak:<\/p>\n\n\n\n\n\n
    Sat\u0131\u015f Temsilcisi<\/th>\nToplam Sat\u0131\u015f<\/th>\n<\/tr>\n
    Ali<\/td>\n5000<\/td>\n<\/tr>\n
    Ay\u015fe<\/td>\n7000<\/td>\n<\/tr>\n
    Mehmet<\/td>\n5500<\/td>\n<\/tr>\n<\/table>\n
      Form\u00fcl: Y\u00dcZDERANK.HRC(Ay\u015fe\u2019nin_sat\u0131\u015flar\u0131; B2:B4) Sonu\u00e7: 0.67 <\/code> <\/pre>\n
    Bu tabloya g\u00f6re Ay\u015fe’nin sat\u0131\u015f performans\u0131, toplam i\u00e7inde %67’lik bir dereceye sahiptir, bu da onun y\u00fcksek sat\u0131\u015f yapt\u0131\u011f\u0131n\u0131 ve s\u0131ralamada \u00fcst s\u0131ralarda oldu\u011funu belirtir.<\/p>\n
    2. Akademik Ba\u015far\u0131 S\u0131ralamas\u0131:<\/b><\/p>\n
    Bir s\u0131n\u0131ftaki \u00f6\u011frencilerin matematik s\u0131nav\u0131 sonu\u00e7lar\u0131n\u0131 g\u00f6re y\u00fczdelik s\u0131ralamas\u0131n\u0131 hesaplamak:<\/p>\n\n\n\n\n\n
    \u00d6\u011frenci<\/th>\nMatematik Puan\u0131<\/th>\n<\/tr>\n
    Elif<\/td>\n88<\/td>\n<\/tr>\n
    John<\/td>\n92<\/td>\n<\/tr>\n
    Doe<\/td>\n77<\/td>\n<\/tr>\n<\/table>\n
      Form\u00fcl: Y\u00dcZDERANK.HRC(Elif'in_puan\u0131; B2:B4) Sonu\u00e7: 0.5 <\/code> <\/pre>\n
    Elif’in matematik puan\u0131 88 ile s\u0131n\u0131f\u0131n y\u00fczdelik olarak orta diliminde, yani %50’lik diliminde yer ald\u0131\u011f\u0131 g\u00f6r\u00fclmekte. Bu, s\u0131n\u0131f ortalamas\u0131nda oldu\u011funu g\u00f6sterir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir veri k\u00fcmesi i\u00e7erisinde bir de\u011ferin y\u00fczdelik s\u0131ras\u0131n\u0131 (01, hari\u00e7) 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-15582","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) 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\/percentrank-exc\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) 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\/percentrank-exc\/\" \/>\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:33:25+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 PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) 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\/percentrank-exc\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/percentrank-exc\/\",\"name\":\"Excel'de PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) 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:33:25+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) 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\/percentrank-exc\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/percentrank-exc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/percentrank-exc\/#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\":\"Y\u00dcZDERANK.HRC\"}]},{\"@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 PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) 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\/percentrank-exc\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) 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\/percentrank-exc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:25+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) 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\/percentrank-exc\/","url":"https:\/\/functiontranslator.com\/tr\/percentrank-exc\/","name":"Excel'de PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) 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:33:25+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da PERCENTRANK.EXC (Y\u00dcZDERANK.HRC) 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\/percentrank-exc\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/percentrank-exc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/percentrank-exc\/#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":"Y\u00dcZDERANK.HRC"}]},{"@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\/15582","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=15582"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15582\/revisions"}],"predecessor-version":[{"id":27061,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15582\/revisions\/27061"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}