Rank problem

**luk** · 10-15-2009, 10:01 AM

I'm working on a League ladder for Lawn Bowls, and have hit a brickwall trying to complete it.
I have columns for Win, Loss, Draw, Shots Up/Down and Points.
Everything appears to be working except for this one ranking glitch.

The problem is the teams are ranked by points but when 2 or more teams have equal points I need the shots up/down column to determine their placing, instead they are being ranked alphabetically..

I am new at this and would appreciate some help, thankyou

**DonkeyOte** · 10-15-2009, 10:12 AM

Welcome to the Board.

First - you can shorten the formula being used in columns F3:G9

F3: =SUMIF('DIV 1 Scores'!$B$4:$B$174,$B3,'DIV 1 Scores'!$F$4:$F$174)
copy down to F9

G3: =SUMIF('DIV 1 Scores'!$B$4:$B$174,$B3,'DIV 1 Scores'!$E$4:$E$174)
copy down to G9

I would then (given relatively small no. of calcs) dispense with RANK and revert to a SUMPRODUCT based approach in Column A such that

A3: =1+SUMPRODUCT(--(($G$3:$G$9+($F$3:$F$9/1000))>($G3+($F3/1000))))
copy down to A9

**luk** · 10-15-2009, 11:27 AM

DonkeyOte thank you so much for your Welcome and your quick reply to my problem.

I have made the changes you suggested and it appears to be working perfectly.

It is very late now, but tomorrow morning I will work on the rest of the sheets and give it a dummy run to be sure it has no glitches.

If you have any other suggestions as to streamlining any other parts of this Ladder your invaluable assistance would be hugely appreciated, as I need to be sure that the results that get posted are correct, otherwise I will have a lot of angry Bowlers after my head...

Once again thankyou!
Luk