=IF(B2<>0,1+SUMPRODUCT(($A$2:$A$9=A2)*($B$2:$B$9<>0)*($B$2:$B$9<B2)),"")

HTH,
Bernie
MS Excel MVP


"h317" <h317.20efky_1135183502.7803@excelforum-nospam.com> wrote in message
news:h317.20efky_1135183502.7803@excelforum-nospam.com...
>
> Thanks, Bernie. It works great. Now I found myself in another
> situation:
>
> There are players who did not show up for games and the scorer assign a
> score of 0 to those players. When we do the ranking, those absent
> players, whose scores are 0, should be exclueded from the ranking. How
> can the formula that you created be changed to accocomodate for this?
> Thanks.
>
>
> --
> h317
> ------------------------------------------------------------------------
> h317's Profile: http://www.excelforum.com/member.php...o&userid=17043
> View this thread: http://www.excelforum.com/showthread...hreadid=494871
>