Results 1 to 31 of 31

Stats (points) tracking for a disc golf league

Threaded View

  1. #6
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    502

    Re: Stats (points) tracking for a disc golf league

    This is what we have so far:

    I have created a starting point and a dummy tournament League.

    Formulas Used

    Rank Formula
    =RANK(F10,$F$10:$F$25,0)+COUNTIF(F10:F$10,F10)-1 Needs to be scrolled down through the Scoring Range
    RANK looks through all of the scores from the Tournament tab and assigns a rank to that number compared to the other players scores.

    Offset Formula
    =OFFSET(E$10,MATCH(SMALL($G$10:$G$25,ROW()-ROW(E$10)+1),$G$10:$G$25,0)-1,0) Needs to be scrolled down through the Scoring Range
    OFFSET looks at all of the scores from the Ranking column and assigns the players names in RANK Order.

    IFERROR - INDEX - MATCH Formula
    =IFERROR(INDEX($F$10:$F$25,MATCH(I10,$E$10:$E$25,0)),"")
    INDEX looks through the Score column and matches the RANKED NAMES to the Players actual game score.
    the IFERROR checks the values in the range for errors and returns the value or a blank if there is an error

    To create a New Tournament Tab
    Right click on the previous tab (6) name and select 'Move or Copy' then select 'Info' then check create a Copy
    a new sheet will then be created at the end of the Tourney tabs. Change the data to reflect the New Tournament
    To rename a Tab
    Right click on the previous tab name and select 'Rename'
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. golf league stats
    By Darlingchivers in forum Excel General
    Replies: 3
    Last Post: 06-07-2017, 01:25 AM
  2. Disc Golf Flight Chart
    By nickdixon14 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-05-2016, 02:16 PM
  3. Excel Golf score & stats tracker
    By davyH in forum Excel General
    Replies: 4
    Last Post: 07-13-2015, 11:32 PM
  4. Making Workbook for Disc Golf Bag Tag Events - Need Help With Macro To Auto Sort Divisions
    By LastBoyScout in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2012, 06:52 PM
  5. Disc Golf Player Rank Help
    By trichard311 in forum Excel General
    Replies: 7
    Last Post: 02-19-2012, 05:23 AM
  6. Excel 2007 : Disc golf scoring and ranking
    By trichard311 in forum Excel General
    Replies: 0
    Last Post: 02-07-2012, 05:43 PM
  7. Premier League Stats
    By gbWildy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2007, 02:18 PM

Tags for this Thread

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