Rank by flight

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.

=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
>