Wade Smart wrote:
John Kaufmann wrote:
In a message dated 2009.10.04 23:45 -0500, Wade Smart wrote:
I have many columns, for example = B19,D19,F19,H19,J19,L19, that
represent team total points.
Well, 'B19,D19,F19,H19,J19,L19' are of course cells, not columns. Are
you saying that every other column (B-D-F-H-J-L) is a team, and totals
are in row 19?
I want to rank them automatically so I dont have to do it each week
manually. Is there any way to do this other than something like "if
this is bigger than this, etc, etc.. "???
Rank how? Are you wanting to actually /move/ columns, or add another
row (say, row 20?) for "Rank", which provides a ranking according to
the totals in row 19?
John
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Let me state that more clearly.
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.
So if there are say 10 teams in this particular league, what I would
like to do in B21 is: from the number of teams, which place is this
team. So the team in first place would have the most points would be 1
and so on.
Each week I update the stats for all the leagues. Thanks to this group
:D, I have been able to automate the updating of the points, scores,
number of games played, number of games left, wins, loss, ties for each
time.
What I would like to see happen is, when my points cell (B19 for Team 1)
is updated, B21 would update accordingly across the board. It would look
at Row 19 cells B,d,f,h,j,l etc for the number of teams in that league
and based on the current point, rank each time.
I can see physically what Im saying and I know what Im trying to say but
Im not sure if its coming across that way.
Wade
Use the rank function.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
