Displaying the difference of the lowest in a range

**bobbby1949** · 03-17-2011, 07:00 PM

I am making golf score cards. There will be four players on each card. Each will have a handicap number. I want to display in a cell next to each player's name, the difference his handicap is compared to the lowest handicap of the four players.

Players names would be A7, A8, A9, A10
The handicap number would be Z7, Z8, Z9, Z10
I would want to display the difference in B7, B8, B9, B10

I would also like to do the same thing on another card where the difference is 80% of the lowest player's handicap.

Any suggestion would be welcomed.

**MarvinP** · 03-17-2011, 07:24 PM

Hi bobbby1949,

Using the Minimum function of the 4 players handicaps is what you are looking for.

Say their handicaps are (10, 12, 9, 15) The Min( 10,12,9,15) is 9 . So you want in B7 = 10 - Min( the four handicaps) etc.

Hope that helps. If not then supply a short sample workbook using "Go Advanced" and then click on the Paper Clip Icon to attach a sample.

**bobbby1949** · 03-17-2011, 08:13 PM

Marvin, It works fine for the 100% return. Thanks a lot.

But I have tried several ways to get the 80%, and result has been incorrect.

If I want the result displayed in B19:

=Z19-MIN(Z19:Z22)

Where do I put the *.80

**MarvinP** · 03-17-2011, 08:24 PM

Please Login or Register  to view this content.

But lets think about this. Is this an index or a hole handicap? If an index then decimal values are ok. But if how many strokes the best player needs to give the others, you have to round it. Right?

Perhaps you want

Please Login or Register  to view this content.

?

**bobbby1949** · 03-17-2011, 08:51 PM

Marvin, I tried the code you suggested before my last reply. It comes up with a larger number. Example: 16 stoke difference comes up as 18 instead of 13...???

The *.80 seems logical to me, but it isn't working correctly.

Btw, you are absolutely correct, we have to use ROUND function.

**MarvinP** · 03-17-2011, 09:10 PM

Please Login or Register  to view this content.

My fault. I missed a set of parens.

**bobbby1949** · 03-17-2011, 09:21 PM

Now we're there. That is where I seem to have my problems. The extra parentheses.

Thank you very much.

My next project for this score card will be to figure out a code that will place a mark in each of the cells that the player receives a stroke. That would be based on the most difficult holes according to each hole's handicap rating. If a player gets 6 strokes, I would want to place a mark in the holes that are rated 1, 2, 3, 4, 5, 6. Perhaps conditional formatting will work.

I'll have to rest my little brain a while before we try tackling that one.

Thanks again.

**MarvinP** · 03-17-2011, 09:41 PM

Hi bobbby,

I've been doing our Golf Club against other Golf Clubs (Home and Home or Sr Exchange) for a few years.
See my master that has a scorecard and routines to put scorecard dots on the correct holes.

I'm not sure I have a Handicaps off the best player in the foursome like you want though.

There are formulas on the scorecard tab for putting dots on each hole. Hope this helps.

I've also written a User Defined Function to put dots on the scorecard of:

Please Login or Register  to view this content.

Have fun with this.

**bobbby1949** · 03-17-2011, 11:19 PM

W O W! This is wonderful.

Btw, you did have the code that I needed for my scorecards. I configured it to mine, and it looks like it is perfect.

The workbook I built for my club is a little different than what you have. It handles the pairings, registration, master scorecard (where I enter all the scores on one sheet which calculates the clears, birdies, eagles, low net, points, and standings), two separate side pools (100% and 80%), recap sheet, and complete results sheet for the event, including the prize monies distributed.

But, I think I may be finding some new things with what you have provided. I still have a long way to go before I can write complex macros. I have been playing with some simple macros on the Club Championship Series workbook. It is a running tally of points for a required minimum number of events to qualify. Our season starts in two weeks and can't wait to see if all the glitches have been worked out.

Marvin, can't tell you how much I appreciate your generous help.

Thank you.