Results 1 to 7 of 7

Tennis Ladder Formula

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2011
    Location
    Albury, Australia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Tennis Ladder Formula

    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
    Last edited by phalpin; 10-08-2011 at 07:44 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1