How to get Ranking of the Students in Excel using RANK Function

=RANK(number,ref,[order])

To rank in descending order, we will use the formula =RANK(B2,($C$5:$C$10),0)

If we want unique ranks, we can use the formula:

=RANK(C5,$C$5:C$10,0)+COUNTIF($C$5:C5,C5)-1

For ascending order, the formula would be:

=RANK.EQ(C5,$C$5:C$10,1)+COUNTIF($C$5:C5,C5)-1

Prevent duplicate entry in excel.

On the Settings tab, choose "Custom" from the Allow drop down list and enter =COUNTIF($D:$D,D2)=1 into the Formula box