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 doesnt 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!

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!

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!

Sorry One last request, I have added an area to keep track of Favorite wins
and Doggie wins can a formula be created around this as well.

You'll see an example under week 1 I promise this will be the last request
from me.

Time to start reading or start paying your for your time. :)

Thanks


"Killer" wrote:

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!

No problem.

I would recommend some changes in some of your formulas. Your file is
already "big" and you don't even have any data in it yet. If you kept things
the way they are by the time you reached week 17 this file would be almost
unusable. I'm going to replace all of those formulas on the Master sheet
(not efficient).

Give me a couple of days.

Biff

"Killer" wrote in message
...
Sorry One last request, I have added an area to keep track of Favorite
wins
and Doggie wins can a formula be created around this as well.

You'll see an example under week 1 I promise this will be the last request
from me.

Time to start reading or start paying your for your time. :)

Thanks


"Killer" wrote:

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!

I have no idea that this could become a problem but you are know what you
talking about so please take your time. I look forward to this and also
learning from your work.

Thanks Again Biff


"T. Valko" wrote:

No problem.

I would recommend some changes in some of your formulas. Your file is
already "big" and you don't even have any data in it yet. If you kept things
the way they are by the time you reached week 17 this file would be almost
unusable. I'm going to replace all of those formulas on the Master sheet
(not efficient).

Give me a couple of days.

Biff

"Killer" wrote in message
...
Sorry One last request, I have added an area to keep track of Favorite
wins
and Doggie wins can a formula be created around this as well.

You'll see an example under week 1 I promise this will be the last request
from me.

Time to start reading or start paying your for your time. :)

Thanks


"Killer" wrote:

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!