Hi Bob

Sorry I got ahead of myself and forgot to read all the way down so didn't
see the part in advent of a tie.

put this in C3 and copy down and across as I mentioned in my last post

=IF(SUMPRODUCT((B$14:B$10000)*($A$14:$A$1000=$A3) *(B$14:B$1000=MIN(B$14:B$1000)))=1,5*COLUMN(B1)-SUM($B$3:B3),0)

Hope this helps!
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!