+ Reply to Thread
Results 1 to 13 of 13

Auto sort golf tournament spreadsheet

Hybrid View

  1. #1
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Auto sort golf tournament spreadsheet

    @ leo73pk

    The main difference in the two approaches are the number of sheets involved, it's really up to Tim which way he wants to go.

    You have only allowed for the situation where all the scores are different, my solutions sort the players alphabetically by surname when the scores are tied.
    On reflection this might benefit by another sort key for "Handicap", again only Tim can tell us the rule if this is the case.

    Your code will run on 2003 and above, mine is for 2007 and above, this may or may not be a problem, depends if the sheet is being distributed to others.
    Last edited by Marcol; 01-10-2011 at 02:32 PM. Reason: Typos

  2. #2
    Forum Contributor leo73pk's Avatar
    Join Date
    09-28-2006
    Location
    UAE
    MS-Off Ver
    2016, Microsoft 365
    Posts
    294

    Re: Auto sort golf tournament spreadsheet

    @ Marcol,

    Thanks for the detailed reply in an expeditious manner.

    In fact my macro is with the consideration of ranking on two parameters. In case the Net Points are same for two or more players then the next criteria will be Gross Points which automatically covers the impact of his column Handicap. (But you are right we both are not familiar with this Golf Scoring i.e. Handicap).

    So lets wait for Tim's reply to further explain his requirement & the field "Handicap".

    Thanks again.

+ Reply to Thread

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