• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

Excel RANK Function

The RANK function returns the rank or position of a number within a range of numbers.

Duplicate numbers are given the same rank. This then affects the ranking of subsequent numbers. For example, if number 8 appears twice and has a rank of 4, then 9 would have a rank of 6 and no number would be ranked number 5.

The syntax for the RANK function is:

=RANK(number, ref, [order])

ArgumentPurpose
numberThe number whose rank you want to find
refThe range of numbers that you want to find the ranking position within
orderHow to rank the number. 0 for descending order and 1 for ascending.Order is optional and if omitted, 0 is entered

The example below demonstrates the RANK function being used to position the numbers in a range of cells.

Excel RANK function returns the rank of a number within a set of numbers
FunctionResult
=RANK(A2,A2:A6)2
=RANK(A3,A2:A6,1)5

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • Conditional Formatting Multiple Columns – 3 Examples
  • IF Function in Power Query Including Nested IFS

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·