Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Data Series in Excel
  • Get column name from index in Excel Table
  • How To Perform and Interpret Regression Analysis in Excel
  • How to calculate current stock or inventory in Excel
  • Working With Tables in Excel

References

  • How to get address of last cell in range in Excel
  • How to reference named range different sheet in Excel
  • Basic INDEX MATCH approximate in Excel
  • How to use Excel INDIRECT Function
  • How to get first column number in range in Excel

Data Validations

  • Excel Data validation no punctuation
  • Excel Data validation must contain specific text
  • Prevent invalid data entering in specific cells
  • Excel Data validation specific characters only
  • Excel Data validation only dates between

How to Use RANK function in Excel

by

The RANK function returns the rank of a number in a list of numbers. RANK gives duplicate numbers the same rank.

This tutorials shows how to rank a set of numeric values, where the highest value is ranked #1 in Excel.

To achieve this you can use the RANK function.

Formula

=RANK(value,data)

See Examples of  Excel Rank function  below:

1. If the third argument is omitted (or 0), Excel ranks the largest number first, second largest number second, etc.

Note: when we drag the RANK function down, the absolute reference ($A$1:$A$9) stays the same, while the relative reference (A1) changes to A2, A3, A4, etc.

2. If the third argument is 1, Excel ranks the smallest number first, second smallest number second, etc.

3. Use the RANK.AVG function to return the average rank if more than one number has the same rank.

4.

Explanation

In the example shown, the formula in D6 is:

=RANK(C6,scores)

Where scores is the named range C6:C13.

How this formula works

You can use the RANK function to rank numeric values.

RANK has two modes of operation: ranking values where the largest value is #1 (order = 0), and ranking values where the lowest value is #1 (order = 1).

In this case, we are ranking test scores, so the highest value should rank #1, so we omit the order argument, which defaults to zero:

=RANK(C6,scores)

The following formula, which includes order set to zero, is equivalent:

=RANK(C6,scores,0)

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel XOR Function
  • Nested IF function example in Excel
  • SWITCH function example in Excel
  • FALSE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get work hours between dates custom schedule in Excel
  • Convert decimal seconds to Excel time
  • Add days to date in Excel
  • Calculate days remaining in Excel
  • How to calculate working days left in month in Excel

Grouping

  • If cell contains one of many things in Excel
  • Group arbitrary text values in Excel
  • Map inputs to arbitrary values in Excel
  • Group numbers with VLOOKUP in Excel
  • Group times into 3 hour buckets in Excel

General

  • 44 Practical Excel IF function Examples
  • How to add sequential row numbers to a set of data in Excel
  • AutoRecover file that was never saved in Excel
  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • Count cells less than in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning