Brian Barker wrote:
At 22:45 04/10/2009 -0500, Wade Smart wrote:
I have many columns, for example = B19,D19,F19,H19,J19,L19, that
represent team total points. I want to rank them automatically so I
don't have to do it each week manually.
At 10:03 05/10/2009 -0500, Wade Smart wrote:
For example:
B2 and C2 is Team 1. B2 holds points. C2 holds scores.
B19 holds the sum of the points. B20 holds the sum of the scores. In
B21 is Rank.
The teams from horizontally across the sheet: B&C2, D&E2, F&G2, etc
And in B21, D21, F21 is the ranking.
What's in C19, E19, etc.? If they are empty, try this. Put
=RANK(B19;$B19:$L19)
into B21. Copy it and paste it into D21, F21, etc. This calculates the
rank of B19, D19, etc. in the (fixed) range of values from B19 to L19.
If C19, E19, etc. are not empty, the simplest solution is probably to
copy the values from the relevant cells - B19, D19, etc. - into another
row, where the alternate cells can be empty. Then use that copy as the
range from which to find the rank. If you don't wish to see it in the
result, you can hide that row or put it in a different part of the sheet
or even on another sheet.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Perfect!
I have been someone how locked out of my functions list in Help (see
other post of mine today) so Im glad you showed me this :D
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
