Help with Golf Handicap Please

karenmccabe

New Member
Joined
May 14, 2024
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
Our league needs help with handicaps. This is how we want to keep score:
For the first 5 rounds use the average score
From 6 to 10 rounds use 5 lowest scores
From 11 to 19 rounds use 7 lowest scores
After 20 rounds use the lowest 10 scores

Golf Scores.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAP
1NameHandicap12344678910111213141516171819202122232425262728293031323334353637383940
2Golfer 1108
3Golfer 294
4Golfer 38991
5Golfer 488858988
6Golfer 588
7Golfer 699
8Golfer 7888383887882
9Golfer 8103104102
10Golfer 98594988591
11Golfer 1010096
12Golfer 11939497
13Golfer 12100
14Golfer 13928384
15Golfer 14102111
16Golfer 1578758081
17Golfer 16
18Golfer 17888787
19Golfer 18878992
20Golfer 19108107
21Golfer 20
22Golfer 218987889193
23Golfer 2284928690
24Golfer 23787875778478
25Golfer 2485
26Golfer 2585899695
27Golfer 268590969585847884777880808094957879908887898290738081
Karen's
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
@karenmccabe Welcome.
In order to get a helpful response I think you will need to better explain / illustrate exactly what you are wanting to calculate.
 
Upvote 0

Forum statistics

Threads
1,224,812
Messages
6,181,104
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top