Results 1 to 13 of 13

Auto sort golf tournament spreadsheet

Threaded View

timparker216 Auto sort golf tournament... 01-09-2011, 10:32 PM
leo73pk Re: Auto sort golf tournament... 01-10-2011, 06:38 AM
Marcol Re: Auto sort golf tournament... 01-10-2011, 07:28 AM
leo73pk Re: Auto sort golf tournament... 01-10-2011, 12:57 PM
outofthehat Re: Auto sort golf tournament... 01-10-2011, 05:47 PM
timparker216 Re: Auto sort golf tournament... 01-11-2011, 01:23 PM
Marcol Re: Auto sort golf tournament... 01-10-2011, 01:25 PM
leo73pk Re: Auto sort golf tournament... 01-10-2011, 01:49 PM
Marcol Re: Auto sort golf tournament... 01-10-2011, 02:14 PM
leo73pk Re: Auto sort golf tournament... 01-10-2011, 02:30 PM
FDibbins Re: Auto sort golf tournament... 09-25-2017, 02:26 AM
  1. #9
    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

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