2009/10/6 Wade Smart <[email protected]>: > 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
I'm glad too, because I didn't know this existed… I always used COUNT.IF in some somewhat more complicated formulas… And I didn't even always get the right results from it (unless I used rounded the values in some way)… J.R. > > Wade > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
