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