Explanation
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)
Related formulas
Rank race results
You can use the RANK function to rank numeric values. RANK has two modes of operation: ranking values so that the largest value is ranked #1 (order = 0), and ranking values so that the smallest value is #1 (order = 1). In this case, we are ranking race times. The lowest/fastest value should rank #1...
Rank if formula
Although Excel has a RANK function , there is no RANKIF function to perform a conditional rank. However, you can easily create a conditional RANK with the COUNTIFS function. The COUNTIFS function can perform a conditional count using two or more criteria. Criteria are entered in range/criteria...
Rank with ordinal suffix
Ordinal numbers represent position or rank in a sequential order. They are normally written using a number + letter suffix: 1st, 2nd, 3rd, etc. To get an ordinal suffix for a small set of numbers, you can use the CHOOSE function like this: =CHOOSE(B5,"st","nd","rd","th","th","th","th","th","th","th...
Related functions
RANK Function
The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest time).
Related videos
How to rank values with the RANK function
In this video we'll look at how to rank values in ascending or descending order using the RANK function . Here we have a table that contains five test scores for a group of students and an average score in Column I. How can we rank these students from highest to lowest scores? Well, one option is...
