Hi,

Setup a blank worksheet like this:

from cell A3 to cell A10 type the 8 golfers names
in cell B3 type this formula and copy down to row 10 and across to column S

=IF(SUMPRODUCT((B$14:B$10000)*($A$14:$A$1000=$A3) *(B$14:B$1000=MIN(B$14:B$1000)))0,5,0)
this will assing $5 to each golfer with the lowest scores for all 18 holes

in cell T3 type:

=SUM(B3:S3)
and copy down to T10, this will give you the totals for each golfer

now all you need to do in input your golf scores starting in row 14 on down,
A14 being a golfers name and from B14 to S14 the first golfer's 18 hole
scores!

if you want to total you scores then in T14 type
=SUM(B14:S14)
and copy down as far as needed


Have fun!

HTH
Jean-Guy


" wrote:

Hello everyone. I was wondering if somebody could offer some advice as
how to best approach this dilemma.

Basically I am looking for a formula that helps us keep track of
scores when we go on golf trips. Interesting stuff, huh?

Anyways the basic idea is that we have 8 golfers. We play 72 holes.
Each golfer with the lowest score on each hole wins $5. Based on that
info, could we set something up that would pick the lowest score out
of a given range, and then attribute $5 to the person who had the
lowest score. And if the lowest score was a tie, it carried to the
next hole.

Thanks for your help!