I'm trying to set up a spreadsheet for tournament play. Each flight
pays the top 30%. In a flight of 12 players, it would pay 4
players...1st Gross, 1st Net, 2nd Gross, 2nd Net. I need a formula
that would find the #1 & #2 Gross scores and the #1 & #2 Net scores,
keeping in mind that once the #1 Gross score is determined, the Net
score is cancelled out of the Net ranking as well as when the #1 Net
score is determined, the Gross score is cancelled out. Once I get
that, I can throw in the formula to calculate the Pool money.
Any help would be appreciated.
Thanks!
--
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile:
http://www.excelforum.com/member.php...o&userid=30600
View this thread:
http://www.excelforum.com/showthread...hreadid=502522