Tennis Ladder Formula

**phalpin** · 10-08-2011, 07:42 AM

Hi,

I'm trying to put a ladder together for our local tennis comp. I'm looking for a formula that would organise the teams in asending order for highest POINTS than on highest PERCENTAGE.

Below are the figures I use to work out the ladder positions:

Points (%)

SECTION 1
Bungowannah 16 (88.16)
Burrumbuttock 8 (113.4)
Culcairn 2 (213.3)
Holbrook 0 (46.88)
Jindera 4 (60.71)
Tabletop Ettamogah 16 (164.71)

I usually do the calculations by using sort points in asending order then if any points are equal swap team according to their percentage. This can very time consuming as I do this every week for 80 or so teams.

Any help or suggestions would be very welcome.

Thanks

**xov0ct** · 10-08-2011, 09:15 AM

Hi!

Please see attached.

*I used Sort Function.

**MarvinP** · 10-08-2011, 10:13 AM

Hi phalpin and welcome to the forum,

It sounds like you are trying to sort sort by two columns. Read http://spreadsheets.about.com/od/exc...excel-2007.htm

Does this solve your problem?

**phalpin** · 10-08-2011, 07:42 PM

Marvin,

Your suggestion seems to work best. However can you think of a way I can make this constant? Ie. If I change the points value it automatically changes the positions without having to go to custom sort everytime?

**phalpin** · 10-08-2011, 07:47 PM

xovoct - I tried the sort method you have suggested. Maybe I'm doing it wrong but it isn't sorting highest to lowest for POINTS then PERCENTAGE it sorts highest to lowest for either points or percentage. Am I doing this differently to what you had suggested?

**MarvinP** · 10-09-2011, 01:20 PM

Hi phalpin,

Lots of things can be done to make this "automatic". The problem is that it takes an Event Macro to do it. I'd suggest you do the sort using two columns for a while. Then you can create a macro using the macro recorder to do the work and hang the macro on a button. Then if this makes sense, call the macro from an event.

Things are rarely done "automatically" using computers.

**xov0ct** · 10-09-2011, 08:14 PM

Originally Posted by phalpin

xovoct - I tried the sort method you have suggested. Maybe I'm doing it wrong but it isn't sorting highest to lowest for POINTS then PERCENTAGE it sorts highest to lowest for either points or percentage. Am I doing this differently to what you had suggested?

Hi, Phalpin.

Just a quick question, is "sorting" dependent to other columns?

If not, you may just use the Sort & Filter >> Continue with the current selection.

I also have removed the filter so that the other columns will not be "sorted" out.

Please see the attached file. (See Screenshots tab.)