Hi,
Ok I think I got it.
in B3 put:
Code:
=IF(AND(SUMPRODUCT(($A$14:$A$1000=$A3)*(B$14:B$10000)*(B$14:B$1000=MIN(IF(B$14:B$10000,B$14:B$1000))))0,SUMPRODUCT(($A$14:$A$1000=$A3)*(B$14:B$10000)*(B$14:B$1000=MIN(IF(B$14:B$10000,B$14:B$1000))))=COUNTIF(B$14:B$1000,"="&MIN(IF(B$14:B$10000,B$14:B$1000)))),5,0)
in C3 put:
Code:
=IF(AND(SUMPRODUCT(($A$14:$A$1000=$A3)*(C$14:C$10000)*(C$14:C$1000=MIN(IF(C$14:C$10000,C$14:C$1000))))0,SUMPRODUCT(($A$14:$A$1000=$A3)*(C$14:C$10000)*(C$14:C$1000=MIN(IF(C$14:C$10000,C$14:C$1000))))=COUNTIF(C$14:C$1000,"="&MIN(IF(C$14:C$10000,C$14:C$1000)))),5*COLUMN(B1)-SUM($B$3:B$10),0)
both formulas needs to be entered using Ctrl+Shift+Enter, simply hitting the
enter key will not work, if done correctly you will see curly bracket on each
end of the formula { } in the formula bar, then oopy down and across as
before!
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!