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 ???

Hi,

An example of your data layout would have helped so i've guessed that each
person has a column with their name at the top and 32 spaces below for each
week. So for column A put this in B2 and drag down to B33

=COUNTIF($A$2:$A$33,A2)1

Mike

"JamesInNeedFootballInDeed" wrote:

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 ???

Mike,
First, thank you for your post. I am about to "fiddle" with the function
"=COUNTIF($A$2:$A$33,A2)1". I cannot, at this point, let you know if it was
any help. When doing so is possible, I will.
At the risk of sounding gready, I have another ask. Almost all responces to
my post, request to see, or say "seeing my data" would help. How can I show
my "work so far" to get the help I need? AND is it possible to do so without
it getting pirated. I had one responder request my workbook so that he could
run the same type of football pool next season. I have no problem sharing,
but I would like to have my name on the template entry. How can I handle
this issue. You sound like the type of guy I would not mind seeing it. Can
ya help again? Can we correspond more directly? I have old mail addresses I
could post !

"Mike H" wrote:

Hi,

An example of your data layout would have helped so i've guessed that each
person has a column with their name at the top and 32 spaces below for each
week. So for column A put this in B2 and drag down to B33

=COUNTIF($A$2:$A$33,A2)1

Mike

"JamesInNeedFootballInDeed" wrote:

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 ???

MIKE,
I just discovered savefile.com

"Mike H" wrote:

Hi,

An example of your data layout would have helped so i've guessed that each
person has a column with their name at the top and 32 spaces below for each
week. So for column A put this in B2 and drag down to B33

=COUNTIF($A$2:$A$33,A2)1

Mike

"JamesInNeedFootballInDeed" wrote:

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 ???

Without appearing disrespectful, it is most unlikely that any responders in
this; or most (any) other groups would be inclined to pirate your undoubtedly
credible work, most here have actually mastered countif. It is simply a fact
that a poster is more likely to get help if a couple of simple rules are
followed:-

1. Ask concise questions.
2. Post your own efforts even if they don't work.
3. Provide a sample of your date or accurate description of data layout.
4. Stick to a single thread.

Mike



"JamesInNeedFootballInDeed" wrote:

Mike,
First, thank you for your post. I am about to "fiddle" with the function
"=COUNTIF($A$2:$A$33,A2)1". I cannot, at this point, let you know if it was
any help. When doing so is possible, I will.
At the risk of sounding gready, I have another ask. Almost all responces to
my post, request to see, or say "seeing my data" would help. How can I show
my "work so far" to get the help I need? AND is it possible to do so without
it getting pirated. I had one responder request my workbook so that he could
run the same type of football pool next season. I have no problem sharing,
but I would like to have my name on the template entry. How can I handle
this issue. You sound like the type of guy I would not mind seeing it. Can
ya help again? Can we correspond more directly? I have old mail addresses I
could post !

"Mike H" wrote:

Hi,

An example of your data layout would have helped so i've guessed that each
person has a column with their name at the top and 32 spaces below for each
week. So for column A put this in B2 and drag down to B33

=COUNTIF($A$2:$A$33,A2)1

Mike

"JamesInNeedFootballInDeed" wrote:

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 ???

ok
thanks

"Dave" wrote:

Without appearing disrespectful, it is most unlikely that any responders in
this; or most (any) other groups would be inclined to pirate your undoubtedly
credible work, most here have actually mastered countif. It is simply a fact
that a poster is more likely to get help if a couple of simple rules are
followed:-

1. Ask concise questions.
2. Post your own efforts even if they don't work.
3. Provide a sample of your date or accurate description of data layout.
4. Stick to a single thread.

Mike



"JamesInNeedFootballInDeed" wrote:

Mike,
First, thank you for your post. I am about to "fiddle" with the function
"=COUNTIF($A$2:$A$33,A2)1". I cannot, at this point, let you know if it was
any help. When doing so is possible, I will.
At the risk of sounding gready, I have another ask. Almost all responces to
my post, request to see, or say "seeing my data" would help. How can I show
my "work so far" to get the help I need? AND is it possible to do so without
it getting pirated. I had one responder request my workbook so that he could
run the same type of football pool next season. I have no problem sharing,
but I would like to have my name on the template entry. How can I handle
this issue. You sound like the type of guy I would not mind seeing it. Can
ya help again? Can we correspond more directly? I have old mail addresses I
could post !

"Mike H" wrote:

Hi,

An example of your data layout would have helped so i've guessed that each
person has a column with their name at the top and 32 spaces below for each
week. So for column A put this in B2 and drag down to B33

=COUNTIF($A$2:$A$33,A2)1

Mike

"JamesInNeedFootballInDeed" wrote:

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 ???