Rank list without ties

This tutorial shows how to rank a range of numbers without ties through the use of an Excel formula, with the RANK and COUNTIF functions

EXCEL FORMULA 1. Rank list without ties

EXCEL

Rank list without ties

=RANK(C5,$C$5:$C$11)+COUNTIF($C$5:C5,C5)-1
GENERIC FORMULA

=RANK(number,range)+COUNTIF(dynamic_range,number)-1

ARGUMENTS
number: Number to rank.
range: A range that contains the numbers to rank.
dynamic_range: A dynamic range that contains the numbers to rank.

EXPLANATION
This formula uses the RANK and COUNTIF functions to rank a list of numbers without ties. Meaning if there are two or more of the same numbers in the list the formula will provide them with sequential ranking numbers instead of the same rank.

RELATED TOPICS

Related Topic Description Related Topic and Description
Rank list of value How to rank a list of values
Rank by group How to rank a number by group
Rank ignoring zeros How to rank numbers ignoring zeros (0)
Rank by alphabetical order How to rank text by alphabetical order

RELATED FUNCTIONS

Related Functions Description Related Functions and Description
COUNTIF Function The Excel COUNTIF function returns the number of cells in a range that meet a specified criteria