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

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