Multiple Ranking

[johnrlalor]

With reference to the attached thread
http://www.excelforum.com/excel-work...e-ranking.html

I have a very similar issue but would like the rank for column B to be sorted in ascending order instead of descending order as per the formula below

=RANK(A2,$A$2:$A$84)+SUMPRODUCT(--($A$2:$A$84=A2),--($B$2:$B$84>B2))

Thanks for any help