|
Posted to microsoft.public.excel.misc
|
|
|
formula help
On Nov 9, 3:32 pm, pinmaster
wrote:
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$1000*0)*(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$1000*0)*(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!- Hide quoted text -
- Show quoted text -
Wow, thanks so much for your help! I really appreciate it. Thanks
again for your persistence at making sure it was exactly right. YOU
ARE AWESOME!
|