Forum Discussion

grlloyd106's avatar
grlloyd106
Copper Contributor
Aug 28, 2020

Excel Leader Board

I'm trying to use excel to maintain a leaderboard in an upcoming golf tournament.  The tournament will go on all day and the registration desk will enter golfers and scores.  I'd like to be able to use that data to maintain a leaderboard so that the golfers can see where their group stands.  I need to use the continuously updated data from the registration desk, sort it and have that screen available.  How can I do this with data that is continuously being updated and without changing or rearranging the data the registration desk is using--they need to keep their data in tee-time sequential order?

excel

2 Replies

Sort By
  • GeoffreyBH's avatar
    GeoffreyBH
    Copper Contributor
    Apr 27, 2025

    Where do I go to post a new question about Excel?

    Sorry to trouble you,

  • Bennadeau's avatar
    Bennadeau
    Iron Contributor
    Aug 28, 2020

    Hi grlloyd106,

    See the attached document. Hopefully this will help you.

    I created two tables one for the player , one for the groups. Then I used =sort(table) so it dynamically sorts the table when there's any changes. 

    I think in golf they use "E" in lieu of "0". In this case it won't work. 

    Technically, once the group name and players name is entered, only column D should be needed to update the scores. 

Resources