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

Didn't you see answers to this question in the misc. group?

Have you tried the array formula?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JamesInNeedFootballInDeed"
om wrote in message
...

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

No to both.
I'm attempting the "countif" function suggested from another, smoother, more
patient sounding, discussion groupee!
I'll look into "array".
Thanks

"Ragdyer" wrote:

Didn't you see answers to this question in the misc. group?

Have you tried the array formula?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JamesInNeedFootballInDeed"
om wrote in message
...

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

So far you have multi-posted the same question to at least 3 groups that I can
see and gotten many suggestions and queries.

None of these groups are any more or less smooth or patient.

I thought RD was quite smooth and patient when he replied in the excel.misc
group.


Gord Dibben MS Excel MVP

On Sun, 30 Dec 2007 09:46:02 -0800, JamesInNeedFootballInDeed
om wrote:

No to both.
I'm attempting the "countif" function suggested from another, smoother, more
patient sounding, discussion groupee!
I'll look into "array".
Thanks

"Ragdyer" wrote:

Didn't you see answers to this question in the misc. group?

Have you tried the array formula?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JamesInNeedFootballInDeed"
om wrote in message
...

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

I think my grandkids would get a kick out of me being refereed to as a
"groupee".<bg

As to "patient" ... don't know where that comes into the conversation?

Whether you realize it or not, you're broaching the netiquette of these
groups with your numerous posts on the same subject (question).
As Biff mentioned your original post back in October, and the post in the
misc. group yesterday, you *still* need assistance!

All of us "groupie's" really bend over backwards to provide help and
suggestions to "you guys".

Since you're coming to *us*, don't you think that "When In Rome" would prove
more fruitful?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JamesInNeedFootballInDeed"
om wrote in message
...
No to both.
I'm attempting the "countif" function suggested from another, smoother,
more
patient sounding, discussion groupee!
I'll look into "array".
Thanks

"Ragdyer" wrote:

Didn't you see answers to this question in the misc. group?

Have you tried the array formula?
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"JamesInNeedFootballInDeed"
om wrote in message
...

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, I didn't feel the same smoothness. That's my perception.

I am a new user (only used the talkgroup on 1 other occasion) and since my
last post noted the statement "keep all corospondence within the news group"
and will do so in the future.
I expect I will have to start over as it is becomeing more and more
difficult to track responces and anyone who reads this one is sure to click
off.
I would thank you Gord, as I did RD for suggesting I look into "array", but
your "quary" was worthless.




"Gord Dibben" wrote:

So far you have multi-posted the same question to at least 3 groups that I can
see and gotten many suggestions and queries.

None of these groups are any more or less smooth or patient.

I thought RD was quite smooth and patient when he replied in the excel.misc
group.


Gord Dibben MS Excel MVP

On Sun, 30 Dec 2007 09:46:02 -0800, JamesInNeedFootballInDeed
om wrote:

No to both.
I'm attempting the "countif" function suggested from another, smoother, more
patient sounding, discussion groupee!
I'll look into "array".
Thanks

"Ragdyer" wrote:

Didn't you see answers to this question in the misc. group?

Have you tried the array formula?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JamesInNeedFootballInDeed"
om wrote in message
...

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

I don't know the word "quary" and have not posted anything that would be
considered worthless unless you feel the post you just responded to is
worthless.

Since you have posted in three newsgroups it is no wonder you cannot track
responses.

Good luck with your project and I sincerely hope your concerns about getting
"pirated"(from programming group) turn out to be all for naught.


Gord

On Sun, 30 Dec 2007 10:30:01 -0800, JamesInNeedFootballInDeed
om wrote:

OK, I didn't feel the same smoothness. That's my perception.

I am a new user (only used the talkgroup on 1 other occasion) and since my
last post noted the statement "keep all corospondence within the news group"
and will do so in the future.
I expect I will have to start over as it is becomeing more and more
difficult to track responces and anyone who reads this one is sure to click
off.
I would thank you Gord, as I did RD for suggesting I look into "array", but
your "quary" was worthless.




"Gord Dibben" wrote:

So far you have multi-posted the same question to at least 3 groups that I can
see and gotten many suggestions and queries.

None of these groups are any more or less smooth or patient.

I thought RD was quite smooth and patient when he replied in the excel.misc
group.


Gord Dibben MS Excel MVP

On Sun, 30 Dec 2007 09:46:02 -0800, JamesInNeedFootballInDeed
om wrote:

No to both.
I'm attempting the "countif" function suggested from another, smoother, more
patient sounding, discussion groupee!
I'll look into "array".
Thanks

"Ragdyer" wrote:

Didn't you see answers to this question in the misc. group?

Have you tried the array formula?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JamesInNeedFootballInDeed"
om wrote in message
...

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

RD and Gord,
It's apperant I have aggrevated you both. For that I apologize.

RD, your initial responce gave me the feeling you were scolding me for not
having read the misc. group. At the time I did not know the proper eddiquite
of posting in the same group so others might learn. I felt as thou you were
disiplining me with you opening statement and I reacted. Again, I apologize.

Gord, what you "thought" really had no validity to me or my post. Instead
of attempting to dictate my thoughts I can only suggest that a simple
explanation of what I was doing wrong would have searved your MVPship much
more appropriately. This was but the 2nd time I have used this public
service. I thought I was here to learn to use excel, what I didn't think was
that MS dictated the way their customers think.

I would much prefer this ridiculous waste of all our time ends here. It gets
none of us anywhere.

"Ragdyer" wrote:


I think my grandkids would get a kick out of me being refereed to as a
"groupee".<bg

As to "patient" ... don't know where that comes into the conversation?

Whether you realize it or not, you're broaching the netiquette of these
groups with your numerous posts on the same subject (question).
As Biff mentioned your original post back in October, and the post in the
misc. group yesterday, you *still* need assistance!

All of us "groupie's" really bend over backwards to provide help and
suggestions to "you guys".

Since you're coming to *us*, don't you think that "When In Rome" would prove
more fruitful?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JamesInNeedFootballInDeed"
om wrote in message
...
No to both.
I'm attempting the "countif" function suggested from another, smoother,
more
patient sounding, discussion groupee!
I'll look into "array".
Thanks

"Ragdyer" wrote:

Didn't you see answers to this question in the misc. group?

Have you tried the array formula?
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"JamesInNeedFootballInDeed"
om wrote in message
...

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

Gord's MVPship is recognition by MS of his prolific, supportive, unrewarded,
contribution to the online community. It doesn't mean that he works for MS,
in fact MS employees cannot be MVPs. So MS are not guilty of, or trying to,
dictate anything here.


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"JamesInNeedFootballInDeed"
om wrote in message
...
RD and Gord,
It's apperant I have aggrevated you both. For that I apologize.

RD, your initial responce gave me the feeling you were scolding me for not
having read the misc. group. At the time I did not know the proper
eddiquite
of posting in the same group so others might learn. I felt as thou you
were
disiplining me with you opening statement and I reacted. Again, I
apologize.

Gord, what you "thought" really had no validity to me or my post. Instead
of attempting to dictate my thoughts I can only suggest that a simple
explanation of what I was doing wrong would have searved your MVPship much
more appropriately. This was but the 2nd time I have used this public
service. I thought I was here to learn to use excel, what I didn't think
was
that MS dictated the way their customers think.

I would much prefer this ridiculous waste of all our time ends here. It
gets
none of us anywhere.

"Ragdyer" wrote:


I think my grandkids would get a kick out of me being refereed to as a
"groupee".<bg

As to "patient" ... don't know where that comes into the conversation?

Whether you realize it or not, you're broaching the netiquette of these
groups with your numerous posts on the same subject (question).
As Biff mentioned your original post back in October, and the post in the
misc. group yesterday, you *still* need assistance!

All of us "groupie's" really bend over backwards to provide help and
suggestions to "you guys".

Since you're coming to *us*, don't you think that "When In Rome" would
prove
more fruitful?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JamesInNeedFootballInDeed"
om wrote in message
...
No to both.
I'm attempting the "countif" function suggested from another, smoother,
more
patient sounding, discussion groupee!
I'll look into "array".
Thanks

"Ragdyer" wrote:

Didn't you see answers to this question in the misc. group?

Have you tried the array formula?
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit
!

--------------------------------------------------------------------------
-
"JamesInNeedFootballInDeed"
om wrote in
message
...

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

Thank you Bob.

Saved me the typing.


Gord

On Sun, 30 Dec 2007 23:20:09 -0000, "Bob Phillips"
wrote:

Gord's MVPship is recognition by MS of his prolific, supportive, unrewarded,
contribution to the online community. It doesn't mean that he works for MS,
in fact MS employees cannot be MVPs. So MS are not guilty of, or trying to,
dictate anything here.

ANOTHER COUNTRY HEARD FROM

"Bob Phillips" wrote:

Gord's MVPship is recognition by MS of his prolific, supportive, unrewarded,
contribution to the online community. It doesn't mean that he works for MS,
in fact MS employees cannot be MVPs. So MS are not guilty of, or trying to,
dictate anything here.


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"JamesInNeedFootballInDeed"
om wrote in message
...
RD and Gord,
It's apperant I have aggrevated you both. For that I apologize.

RD, your initial responce gave me the feeling you were scolding me for not
having read the misc. group. At the time I did not know the proper
eddiquite
of posting in the same group so others might learn. I felt as thou you
were
disiplining me with you opening statement and I reacted. Again, I
apologize.

Gord, what you "thought" really had no validity to me or my post. Instead
of attempting to dictate my thoughts I can only suggest that a simple
explanation of what I was doing wrong would have searved your MVPship much
more appropriately. This was but the 2nd time I have used this public
service. I thought I was here to learn to use excel, what I didn't think
was
that MS dictated the way their customers think.

I would much prefer this ridiculous waste of all our time ends here. It
gets
none of us anywhere.

"Ragdyer" wrote:


I think my grandkids would get a kick out of me being refereed to as a
"groupee".<bg

As to "patient" ... don't know where that comes into the conversation?

Whether you realize it or not, you're broaching the netiquette of these
groups with your numerous posts on the same subject (question).
As Biff mentioned your original post back in October, and the post in the
misc. group yesterday, you *still* need assistance!

All of us "groupie's" really bend over backwards to provide help and
suggestions to "you guys".

Since you're coming to *us*, don't you think that "When In Rome" would
prove
more fruitful?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JamesInNeedFootballInDeed"
om wrote in message
...
No to both.
I'm attempting the "countif" function suggested from another, smoother,
more
patient sounding, discussion groupee!
I'll look into "array".
Thanks

"Ragdyer" wrote:

Didn't you see answers to this question in the misc. group?

Have you tried the array formula?
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit
!

--------------------------------------------------------------------------
-
"JamesInNeedFootballInDeed"
om wrote in
message
...

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

<<<"I would much prefer this ridiculous waste of all our time ends here. It
gets
none of us anywhere."

I accept that statement!

Getting back to the nuts and bolts of your question, what happened when you
tried (assume you *did* try) the array formula I posted in the misc. group?

=IF(MAX(COUNTIF(B20:R20,B20:R20))1,"Duplication", "OK")

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
You *must also* use CSE when revising the formula.

Do a test on a new, blank sheet, where you enter various team names, and
you'll see that any duplicates will make the formula return notification
dupes.

You also have an option using "Data Validation" of *preventing* duplicates
from being entered in the first place.

You have an additional option of *flagging* duplicates ... say, turning the
cell red if any dupes are present.

You have a lot of ways to go.

Waiting on you for additional input.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JamesInNeedFootballInDeed"
om wrote in message
...
ANOTHER COUNTRY HEARD FROM

"Bob Phillips" wrote:

Gord's MVPship is recognition by MS of his prolific, supportive,
unrewarded,
contribution to the online community. It doesn't mean that he works for
MS,
in fact MS employees cannot be MVPs. So MS are not guilty of, or trying
to,
dictate anything here.


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"JamesInNeedFootballInDeed"
om wrote in message
...
RD and Gord,
It's apperant I have aggrevated you both. For that I apologize.

RD, your initial responce gave me the feeling you were scolding me for
not
having read the misc. group. At the time I did not know the proper
eddiquite
of posting in the same group so others might learn. I felt as thou
you
were
disiplining me with you opening statement and I reacted. Again, I
apologize.

Gord, what you "thought" really had no validity to me or my post.
Instead
of attempting to dictate my thoughts I can only suggest that a simple
explanation of what I was doing wrong would have searved your MVPship
much
more appropriately. This was but the 2nd time I have used this public
service. I thought I was here to learn to use excel, what I didn't
think
was
that MS dictated the way their customers think.

I would much prefer this ridiculous waste of all our time ends here.
It
gets
none of us anywhere.

"Ragdyer" wrote:


I think my grandkids would get a kick out of me being refereed to as
a
"groupee".<bg

As to "patient" ... don't know where that comes into the
conversation?

Whether you realize it or not, you're broaching the netiquette of
these
groups with your numerous posts on the same subject (question).
As Biff mentioned your original post back in October, and the post in
the
misc. group yesterday, you *still* need assistance!

All of us "groupie's" really bend over backwards to provide help and
suggestions to "you guys".

Since you're coming to *us*, don't you think that "When In Rome"
would
prove
more fruitful?
--
Regards,

RD


-------------------------------------------------------------------------
--
Please keep all correspondence within the NewsGroup, so all may
benefit !

-------------------------------------------------------------------------
--

"JamesInNeedFootballInDeed"
om wrote in
message
...
No to both.
I'm attempting the "countif" function suggested from another,
smoother,
more
patient sounding, discussion groupee!
I'll look into "array".
Thanks

"Ragdyer" wrote:

Didn't you see answers to this question in the misc. group?

Have you tried the array formula?
--
Regards,

RD



--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit
!


--------------------------------------------------------------------------
-
"JamesInNeedFootballInDeed"
om wrote in
message
...

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