Golf League handicap with a twist

**jdaubs** · 05-10-2007, 05:27 PM

This is simular to others posts here for handicaps but a little more complicated. Our Golf league is 16 weeks long. I need a formula that would get the running total of the last 6 scores entered, excluding the highest score. So basically the lowest 5 of the last 6 scores entered. Also, it would have to not count the weeks that people don't show up. Right now I mark this cell with a DNP. Then give the average of those 5 scores multiplied by 90%. Right now I have to move the formual around every week. I've attached the file I'm using now. Any help would be appreciated

**Jazzer** · 05-11-2007, 05:39 AM

Hi,

this should work:

Please Login or Register  to view this content.

To make this work:
1. Open your VBE (Alt+F11)
2. Insert a new Module (Insert -> Module)
3. Copy and paste the above to the editor
4. in Excel type this in cell Z4: =CurrentHandicap(B4:Q4)
5. and copy it down as far as you need

It doesn't matter if there are empty cells in the range of function. If there are no values in the range, it returns 0.

Hope this helps.

- Asser