{"id":3443,"date":"2014-03-04T15:41:32","date_gmt":"2014-03-04T10:11:32","guid":{"rendered":"http:\/\/trumpexcel.com\/?page_id=3443"},"modified":"2023-09-29T15:22:38","modified_gmt":"2023-09-29T09:52:38","slug":"excel-rank-function","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/excel-rank-function\/","title":{"rendered":"How to Use Excel RANK Function (Examples + Video)"},"content":{"rendered":"<h2><span style=\"color: #800000;\">Excel RANK Function (Example + Video)<\/span><\/h2>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-3283\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/RANK-FORMULA-EXCEL.png\" alt=\"Excel RANK Function\" width=\"450\" height=\"330\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/RANK-FORMULA-EXCEL.png 752w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/RANK-FORMULA-EXCEL-409x300.png 409w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/p>\n<h3><span style=\"color: #800000;\">When to use Excel RANK Function<\/span><\/h3>\n<p>RANK function can be used when you want to rank a number against a list of numbers.<\/p>\n<h3><span style=\"color: #800000;\">What it Returns<\/span><\/h3>\n<p>It returns a number that represents the relative rank of the number against the list of numbers.<\/p>\n<h3><span style=\"color: #800000;\">Syntax<\/span><\/h3>\n<p>=RANK(number, ref, [order])<\/p>\n<h3><span style=\"color: #800000;\">Input Arguments<\/span><\/h3>\n<ul>\n<li><strong>number<\/strong> &#8211; the number that you want to rank.<\/li>\n<li><strong>ref<\/strong> &#8211; the list of numbers against which you want to rank the number argument. It could be a\u00a0range of cells or an array.<\/li>\n<li><strong>[order]<\/strong> &#8211; (optional) a number that specifies how to rank (ascending or descending order)<\/li>\n<\/ul>\n<h3><span style=\"color: #800000;\">Additional Notes<\/span><\/h3>\n<ul>\n<li>If Order is:\n<ul>\n<li>0 or omitted \u2013 Highest number gets 1st rank.<\/li>\n<li>1 \u2013 Lowest numbers gets 1st rank.<\/li>\n<\/ul>\n<\/li>\n<li>Duplicate values get the same rank.\n<ul>\n<li>If there are 2 numbers with the 2nd rank, the next number gets a rank of 4. Similarly if 2 numbers have the 2nd rank, the next number gets a rank of 4.<\/li>\n<\/ul>\n<\/li>\n<li>Microsoft team has introduced a new function <a href=\"https:\/\/support.office.com\/en-ca\/article\/RANK-EQ-function-284858ce-8ef6-450e-b662-26245be04a40?ui=en-US&amp;rs=en-CA&amp;ad=CA\" target=\"_blank\" rel=\"noopener noreferrer\">RANK.EQ<\/a>. It works exactly the same way as RANK function. MS team encourages to use this new function for improved accuracy. RANK function has been retained for backward compatibility.<\/li>\n<\/ul>\n<h2><span style=\"text-decoration: underline;\"><span style=\"color: #800000; text-decoration: underline;\">Excel RANK Function &#8211; Live Example<\/span><\/span><\/h2>\n<p><iframe src=\"https:\/\/onedrive.live.com\/embed?cid=7A7F3A8F4121E599&amp;resid=7A7F3A8F4121E599%21174&amp;authkey=AOssI_Xy3bh-VB0&amp;em=2&amp;AllowTyping=True&amp;wdDownloadButton=True\" width=\"580\" height=\"400\" frameborder=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<h2 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #800000; text-decoration: underline;\">Excel RANK Function &#8211; Video Tutorial<\/span><\/span><\/h2>\n<p><iframe title=\"RANK Formula in Excel\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/xeKFxFXCBPE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p><span style=\"color: #800000;\"><strong>Related Excel Functions:<\/strong><\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-int-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel INT Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-mod-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel MOD Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-rand-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel RAND Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-randbetween-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel RANDBETWEEN Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-round-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel ROUND Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-large-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel LARGE Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-max-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel MAX Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-min-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel MIN Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-small-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel SMALL Function<\/a>.<\/li>\n<\/ul>\n<p><strong><span style=\"color: #800000;\">You May Also Like the Following Excel Tutorials:<\/span><\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/rank-within-groups-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Rank within Groups in Excel<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/generate-random-numbers-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Generate Random Numbers in Excel<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel RANK Function (Example + Video) When to use Excel RANK Function RANK function can be used when you want to rank a number against a list of numbers. What it Returns It returns a number that represents the relative rank of the number against the list of numbers. Syntax =RANK(number, ref, [order]) Input Arguments &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Use Excel RANK Function (Examples + Video)\" class=\"read-more button\" href=\"https:\/\/trumpexcel.com\/excel-rank-function\/#more-3443\" aria-label=\"Read more about How to Use Excel RANK Function (Examples + Video)\">Read more<\/a><\/p>\n","protected":false},"author":80,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[153],"tags":[19],"class_list":["post-3443","post","type-post","status-publish","format-standard","hentry","category-excel-functions","tag-excel-how-tos"],"_links":{"self":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/3443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/users\/80"}],"replies":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/comments?post=3443"}],"version-history":[{"count":0,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/3443\/revisions"}],"wp:attachment":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/media?parent=3443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/categories?post=3443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/tags?post=3443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}