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]
