In column A is the name of the accout; column B, minutes, column c, the rank
where the lowest number of minutes is ranked number 1. Any accounts with zero
minutes should not be ranked or should have the highest rank (low minutes are
good; zero minutes means no rank)

Col A Col B Col C
Fred 69 8
Chris 0
North 41.4 6
Alex 52 7
Larry 0
South 0
Olaf 0
Merry 0

I have tried a combination of if and rank functions, such as this one:
=IF(A2=0," ",(RANK(a2,$a$2:$a$10,1))), but the zero minutes is causing the
North account to show a rank of 6 when it should have a rank of 1. Any
asstance would be appreciated. Thank you.