Reverse Rank Order

[klatlap]

Is it possible to use the below rank formula but reverse the ranking?


=IF(MainSheet!G16="","",COUNT($BO$2:$BO$26)-(RANK(BO2,$BO$2:$BO$26)+COUNTIF($BO$2:BO2,BO2)-1)+1)

 

[AlphaFrog]

There is an argument for the RANK function to reverse the rank order.

Syntax:

RANK(number,ref,order)

RANK Function Arguments

 

[klatlap]

That was simple enough, thanks