B
ballb0y
I have been using Excel to track my golf society scores for a couple o
years and it has served me well, however I would like to know if th
following is possible in Excel:
My players play a total of 10 events. After 6 events are completed eac
player's scores are added together and a leaderboard is formed. As the
play more rounds, players who better their 6th worst score can move u
the table.
Although I can successfully calculate and sort the table of scores t
form a list (leaderboard) below in the spreadsheet, I do not know ho
to link the player's name (which is in a separate cell) with the scor
so it would appear as below. I have to do this manually.
John 199
Steve 196
Colin 188
Basically, is this possible? Any help would be appreciated. Thanks
years and it has served me well, however I would like to know if th
following is possible in Excel:
My players play a total of 10 events. After 6 events are completed eac
player's scores are added together and a leaderboard is formed. As the
play more rounds, players who better their 6th worst score can move u
the table.
Although I can successfully calculate and sort the table of scores t
form a list (leaderboard) below in the spreadsheet, I do not know ho
to link the player's name (which is in a separate cell) with the scor
so it would appear as below. I have to do this manually.
John 199
Steve 196
Colin 188
Basically, is this possible? Any help would be appreciated. Thanks