Try this:

=IF(B2=0,"",SUMPRODUCT(--(B$2:B$100),--(B$2:B$10<B2))+1)

--
Biff
Microsoft Excel MVP


"Basenji" wrote in message
...
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.