I am currently running a golf league on excel and I am trying to autoimate it as much as possible and I have two parts I am struggling with.
1. To find the lowest 4 scores in a row. The rows have a score in row 20a , 20c 20e , 20g and so on and I want to find the 4 lowest scores in these cells automatically.
2. The second thing I am trying to do is work out the net score minus stroke index for each player with their different handicap as per below
Gross Nett Gross Nett
9 8 -1
7 6 -1
3 3 0
4 3 -1
5 4 -1
5 5 0
4 3 -1
12 11 -1
8 7 -1
4 3 -1
4 3 -1
12 12 0
3 2 -1
5 4 -1
8 8 -1
4 3 -1
2 1 -1
5 4 -1
104 90 0 -15
14 15
90 0.1 -15
14.5
Bookmarks