HEy Biff

Here's the link you have requested.

http://www.nghl.net/Downloads/Football_Pool.zip

Thanks


"T. Valko" wrote:

If you can post a link to your file (like you did last time) I'll fix ya up!

Biff

"Killer" wrote in message
...
Hey All.

I run an football poll and I'm trying to get away from manually putting
checkmarks beside the players who select the correct team and was
wondering
if it's possible to have this done automatically.

Here's spreadsheet layout example:

A : B C : D
2 Favorite Min
3 Spread 10
4 Underdog Buf

Player:
B C D
6 Pam Minn
7 Sam Buff ?
8 John Buff ?
9 Steve Minn

A : B C D
40 Score Buff 20
41 Minn 23

So the formula should be if the favorite either ties or beats the spread
the
team who took the favorite should receive a checkmark in column D

If the favorite doesn't cover the spread the player who selects the
underdog
should receive a checkmark in column D

The person who didn't select the correct team column D should be left
blank.

Thanks!