Football Pool Fun HELP

[JamesInNeedFootballInDeed]

In Case You Missed My First Post !!!

 

[Mike H]

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]

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 !

 

[JamesInNeedFootballInDeed]

MIKE,
I just discovered savefile.com

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

 

[Dave]

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]

ok
thanks

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