# Spreadsheet for my golf League

1. ## Spreadsheet for my golf League

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

2. ## Re: Spreadsheet for my golf League

I'm not sure what you mean by in a row? can you post a sample work book.

You will use some form of =min() to get the lowest scores.

How do you calculate the stroke index for each player?

3. ## Re: Spreadsheet for my golf League

This is a sample that I need to find the lowest 4 or 6 scores from but it can carry on for around 30 rounds.

Nett 66 71 64 75 70 76 68 75

4. ## Re: Spreadsheet for my golf League

The stroke index works if a player has a handicp of say 14 he gets a shot off his net score on holes 1 - 14 but not on 15, 16, 17 or 18.

The stroke index is as follows

Hole Stroke Index
1 = 10
2 = 6
3 = 18
4 = 2
5 = 14
6 = 16
7 = 8
8 = 4
9 = 12
10 = 11
11 = 5
12 = 17
13 = 7
14 = 1
15 = 15
16 = 3
17 = 13
18 = 9

5. ## Re: Spreadsheet for my golf League

So you would use =LARGE(A1:H1,1) then just increase 1 to 2 then 3 etc..

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

#### 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