H
Harry Limey
I have just posted this in a golf newsgroup, but then it occurred to me I
would probably have more chance going to the specialist group?
I have just been co-opted as secretary to the Senior's section at my golf
club, and I have been trying to set up an Excel programme to use for the
yearly medal trophy.
We play a medal once a month (12 times a year) and the best three rounds for
each player are added together - the person with the lowest 3 scores winning
the trophy.
What I would like to do is set up a sum in Excel which will take the lowest
three scores (for each person) and add them together!. Or if possible have
three boxes for each player detailing their - lowest - second lowest -third
lowest score.
If anyone can help with this or already has a similar programme worked out I
would appreciate the formulae!
Harry
would probably have more chance going to the specialist group?
I have just been co-opted as secretary to the Senior's section at my golf
club, and I have been trying to set up an Excel programme to use for the
yearly medal trophy.
We play a medal once a month (12 times a year) and the best three rounds for
each player are added together - the person with the lowest 3 scores winning
the trophy.
What I would like to do is set up a sum in Excel which will take the lowest
three scores (for each person) and add them together!. Or if possible have
three boxes for each player detailing their - lowest - second lowest -third
lowest score.
If anyone can help with this or already has a similar programme worked out I
would appreciate the formulae!
Harry