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

Data Analysis

  • How to create a Histogram in Excel
  • Excel Pie Chart
  • How To Filter Data in Excel
  • Conditional Formatting Icon Sets Examples in Excel
  • Filter Data Based on Date in Excel

References

  • To count total rows in a range in Excel
  • Find closest match in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to use Excel ROW Function
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation allow uppercase only
  • Data validation must not exist in list
  • Excel Data validation date in specific year
  • Excel Data validation require unique number
  • Excel Data validation unique values only

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

Next Post:

Convert date string to date time in Excel

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

  • How to use Excel OR Function
  • Complete List of Excel Logical Functions, References and Examples
  • IF with boolean logic in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IFS function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Add decimal minutes to time in Excel
  • SECOND function: Description, Usage, Syntax, Examples and Explanation
  • YEAR function: Description, Usage, Syntax, Examples and Explanation
  • How to get number of days, weeks, months or years between two dates in Excel
  • Assign points based on late time in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • Map inputs to arbitrary values in Excel
  • Group numbers with VLOOKUP in Excel
  • Group times into unequal buckets in Excel
  • Group numbers at uneven intervals in Excel

General

  • Check if multiple cells have same value in Excel
  • How to calculate percent of students absent in Excel
  • How to calculate percentage discount in Excel
  • How to calculate decrease by percentage in Excel
  • How to calculate percent of goal in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning