software

For the quot;rank within a flightquot; to work, I need to create two different
formulas for row 1 to 4 and 5 to 8 separately. I was trying to create a
fits-all formulat in the 4th column of the following spreadsheet. I
tried using array function and it did not work. Please help.

Rank Rank
Flight Scores Full Field Flight
A 78 1 1
A 92 6 4
A 90 4 3
A 88 2 2
B 91 5 2
B 98 7 3
B 89 3 1
B 100 8 4

Please help. Thanks.--
h317
------------------------------------------------------------------------
h317's Profile: www.excelforum.com/member.php...oamp;userid=17043
View this thread: www.excelforum.com/showthread...hreadid=494871h317,

For your example table, starting in cell A1:

=1 SUMPRODUCT(($A$2:$A$9=A2)*($B$2:$B$9lt;B2))

HTH,
Bernie
MS Excel MVPquot;h317quot; gt; wrote in message
...
gt;
gt; For the quot;rank within a flightquot; to work, I need to create two different
gt; formulas for row 1 to 4 and 5 to 8 separately. I was trying to create a
gt; fits-all formulat in the 4th column of the following spreadsheet. I
gt; tried using array function and it did not work. Please help.
gt;
gt; Rank Rank
gt; Flight Scores Full Field Flight
gt; A 78 1 1
gt; A 92 6 4
gt; A 90 4 3
gt; A 88 2 2
gt; B 91 5 2
gt; B 98 7 3
gt; B 89 3 1
gt; B 100 8 4
gt;
gt; Please help. Thanks.
gt;
gt;
gt; --
gt; h317
gt; ------------------------------------------------------------------------
gt; h317's Profile: www.excelforum.com/member.php...oamp;userid=17043
gt; View this thread: www.excelforum.com/showthread...hreadid=494871
gt;

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: www.excelforum.com/member.php...oamp;userid=17043
View this thread: www.excelforum.com/showthread...hreadid=494871=IF(B2lt;gt;0,1 SUMPRODUCT(($A$2:$A$9=A2)*($B$2:$B$9lt;gt; 0)*($B$2:$B$9lt;B2)),quot;quot;)

HTH,
Bernie
MS Excel MVPquot;h317quot; gt; wrote in message
...
gt;
gt; Thanks, Bernie. It works great. Now I found myself in another
gt; situation:
gt;
gt; There are players who did not show up for games and the scorer assign a
gt; score of 0 to those players. When we do the ranking, those absent
gt; players, whose scores are 0, should be exclueded from the ranking. How
gt; can the formula that you created be changed to accocomodate for this?
gt; Thanks.
gt;
gt;
gt; --
gt; h317
gt; ------------------------------------------------------------------------
gt; h317's Profile: www.excelforum.com/member.php...oamp;userid=17043
gt; View this thread: www.excelforum.com/showthread...hreadid=494871
gt;