Forum Discussion
grlloyd106
Aug 28, 2020Copper Contributor
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 u...
Bennadeau
Aug 28, 2020Iron Contributor
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.