File on it's way.

Biff

"bob" wrote in message
...
send to

thanks for all the help
--
bob



"Biff" wrote:

Ok, just let me know where to send the file.

Biff

"bob" wrote in message
...
heck yea ill take it !!!!!
this is for a complete season each person will be in it each week so if
there are any changes you might think i need to make ket me know!!!and
thanks
for the help i am sooo happy:)
--
bob



"Biff" wrote:

Well, it doesn't do EXACTLY what you want....

Instead of returning a "Win" or "Loss" I use conditional formatting to
highlight the wins or losses.

My file is for the NFL. It's already setup for the upcoming season.
Each
week the people in the pool make their picks then each week is
summarized
and a running total is calculated along with a winning %. I also have
it
weighted because each week the number of people that participate
changes.
That way, if someone only picks 1 week and goes 16-0 with a winning
percentage of 1.000 they will not win over someone who picks every
week
and
has a lower winning percentage.

Biff

"Biff" wrote in message
...
Hi!

I have a file that does exactly what you want. Want a copy?

Biff

"bob" wrote in message
...
hello
First i dont even know is this is possible orif i am using the
right
program
but...i would like to set excell for a football pool where each
players
pick
is matched against the outcome of that game and will enter the
value
win
or
loss i used the formula =IF(AND(D2=B2,D2<C2),"win","loss") but
its
not
error proof also i would like a function add up all the win and
losses
to
get
a win loss record for that week i.e. 11-5 if thats possible you are
a
god
and
i am the happiest person alive
--
bob