Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GOLF Spreadsheet problem
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Linking formula to external spreadsheet | Excel Discussion (Misc queries) | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |