| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Football Pool Fun HELP
In Case You Missed My First Post !!!
I'm producing a template for a football pool I am in. It's called a "Margin Of Victory" pool. Just like most, the person with the most points at the end of the NFL season wins. It works just like the name. Each person chooses on NFL team each week. Points are awarded or deducted for the "Margin" of points the NFL team the person chose won by. "Victory" ex: I chose the Philadelphia Eagles this week and they beat the Carolina Panthers 28 to 7. I, for choosing the Eagles, am awarded 21 points. Another person, who had the Panthers this week would have -21, or 21 points deducted from his/her running total. Heres the trick, and my problem for this post. Each person in the pool can choose the same team from each of the 32 NFL teams once. In other words, my choice of the Eagles is available to me only once in the 17 week season. I need a formula that notifies the input person that I can't have the Eagles this week because I used them in week 10. Surely there is a formula that recognizes PHI, (the abbreviation for Philadelphia) and notifies the input person. I was thinking perhaps a "True" or "False" value in the column next to each persons name. Can Anyone Help ??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Football Pool Function | Excel Worksheet Functions | |||
| Football pool | Excel Programming | |||
| football pool schedule | Excel Discussion (Misc queries) | |||
| Football pool | Excel Discussion (Misc queries) | |||
| football pool template | New Users to Excel | |||
Threaded Mode
