Actually, the following would suffice...

=IF(B5<"",RANK(B5,$B$5:$B$14,1),"")

In article ,
Domenic wrote:

Try...

=IF(B5<"",SUMPRODUCT(--($B$5:$B$14<""),--(B5$B$5:$B$14))+1,"")

Hope this helps!