{"id":1394,"date":"2018-07-04T10:50:48","date_gmt":"2018-07-04T10:50:48","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1394"},"modified":"2023-11-03T11:06:25","modified_gmt":"2023-11-03T11:06:25","slug":"rank-function","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/rank-function\/","title":{"rendered":"RANK function"},"content":{"rendered":"\n<p>The rank function in Excel is a useful tool that allows you to determine the relative position or ranking of a specific value in a list of values. It assigns a rank to each value based on its position in the list, helping you analyze and compare data easily.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>RANK(number, ref, [order])<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><b>number<\/b><\/td><td>The number you want to rank within the list.<\/td><\/tr><tr><td><b>ref<\/b><\/td><td>The list of values among which you want to rank the &#8216;number&#8217;.<\/td><\/tr><tr><td><b>[order]<\/b><\/td><td>(Optional) An optional argument that specifies the ranking order. If omitted, it defaults to descending order (the largest value gets a rank of 1).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to use<\/h2>\n\n\n\n<p>The RANK function is straightforward to use. Let&#8217;s go through some examples to understand it better.<\/p>\n\n\n\n<p>Suppose you have a list of test scores in cell range A1:A5, and you want to find the rank of a score, say 85, within that list. Here&#8217;s how you can use the RANK function:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=RANK(85, A1:A5)<\/code><\/pre>\n\n\n\n<p>This formula will return the rank of the value 85 within the list A1:A5.<\/p>\n\n\n\n<p>Now, if you want to specify the ranking order as ascending (the smallest value gets a rank of 1), you can do so like this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=RANK(85, A1:A5, 1)<\/code><\/pre>\n\n\n\n<p>Adding &#8220;1&#8221; as the third argument indicates ascending order.<\/p>\n\n\n\n<p>Additionally, if you have duplicate values in the list and you want to handle ties, you can use the RANK.EQ and RANK.AVG functions. RANK.EQ assigns the same rank to identical values, while RANK.AVG assigns an average rank to them. Here&#8217;s an example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=RANK.EQ(85, A1:A5)<\/code><\/pre>\n\n\n\n<p>Or for RANK.AVG:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=RANK.AVG(85, A1:A5)<\/code><\/pre>\n\n\n\n<p>These functions provide different ways to handle tied values within the list.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Examples<\/h2>\n\n\n\n<p>Let&#8217;s say you have the following data:<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td>Student<\/td><td>Test Score<\/td><\/tr><tr><td>John<\/td><td>90<\/td><\/tr><tr><td>Mary<\/td><td>85<\/td><\/tr><tr><td>Lisa<\/td><td>90<\/td><\/tr><tr><td>Mike<\/td><td>78<\/td><\/tr><tr><td>Susan<\/td><td>95<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>To find the rank of Mary&#8217;s score (85) in descending order:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=RANK(85, B2:B6)<\/code><\/pre>\n\n\n\n<p>This will return a rank of 3 for Mary&#8217;s score.<\/p>\n\n\n\n<p>For ascending order:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=RANK(85, B2:B6, 1)<\/code><\/pre>\n\n\n\n<p>This formula will return a rank of 2 for Mary&#8217;s score in ascending order.<\/p>\n\n\n\n<p>Using RANK.EQ:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=RANK.EQ(90, B2:B6)<\/code><\/pre>\n\n\n\n<p>This formula will return a rank of 1 for the highest score (90), and:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=RANK.EQ(90, B2:B6, 1)<\/code><\/pre>\n\n\n\n<p>Will also return 1 in ascending order.<\/p>\n\n\n\n<p>Using RANK.AVG:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=RANK.AVG(90, B2:B6)<\/code><\/pre>\n\n\n\n<p>With RANK.AVG, if two values share the same rank (as with the two scores of 90), it will return an average rank, so it will return 1.5 in this case.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Additional Information<\/h2>\n\n\n\n<p>The RANK function in Excel is a handy tool for comparing and analyzing data. It&#8217;s important to understand how to use it in different scenarios, especially when dealing with duplicate values and specifying the ranking order. Remember to adjust the function to your specific needs, whether you want to rank in ascending or descending order, and whether you prefer to handle tied values with RANK.EQ or RANK.AVG.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The rank function in Excel is a useful tool that allows you to determine the relative position or ranking of a specific value&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>RANK function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/rank-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RANK function\" \/>\n<meta property=\"og:description\" content=\"The rank function in Excel is a useful tool that allows you to determine the relative position or ranking of a specific value...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/rank-function\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T10:50:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T11:06:25+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rank-function\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rank-function\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"RANK function\",\"datePublished\":\"2018-07-04T10:50:48+00:00\",\"dateModified\":\"2023-11-03T11:06:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rank-function\/\"},\"wordCount\":449,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rank-function\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/rank-function\/\",\"name\":\"RANK function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T10:50:48+00:00\",\"dateModified\":\"2023-11-03T11:06:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rank-function\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/rank-function\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rank-function\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RANK function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"RANK function","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:\/\/officetuts.net\/excel\/functions\/rank-function\/","og_locale":"en_US","og_type":"article","og_title":"RANK function","og_description":"The rank function in Excel is a useful tool that allows you to determine the relative position or ranking of a specific value...","og_url":"https:\/\/officetuts.net\/excel\/functions\/rank-function\/","article_published_time":"2018-07-04T10:50:48+00:00","article_modified_time":"2023-11-03T11:06:25+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/rank-function\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/rank-function\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"RANK function","datePublished":"2018-07-04T10:50:48+00:00","dateModified":"2023-11-03T11:06:25+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/rank-function\/"},"wordCount":449,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/rank-function\/","url":"https:\/\/officetuts.net\/excel\/functions\/rank-function\/","name":"RANK function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T10:50:48+00:00","dateModified":"2023-11-03T11:06:25+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/rank-function\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/rank-function\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/rank-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"RANK function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1394"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1394"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1394\/revisions"}],"predecessor-version":[{"id":16531,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1394\/revisions\/16531"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}