Football Pool Function

[JamesInNeedFootballInDeed]

 

[Ragdyer]

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

Have you tried the array formula?

 

[JamesInNeedFootballInDeed]

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

 

[Gord Dibben]

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

 

[Ragdyer]

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?

 

[JamesInNeedFootballInDeed]

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]

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

 

[JamesInNeedFootballInDeed]

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.

 

[Bob Phillips]

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"

 

[Gord Dibben]

Thank you Bob.

Saved me the typing.


Gord

 

[JamesInNeedFootballInDeed]

ANOTHER COUNTRY HEARD FROM

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"

 

[Ragdyer]

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