Summary of Data from a Range

I have a range of data, which is a weekly sports picking competition at work.

Basically on the left it has the event, and along the top it has my work
colleagues names.

The sports picks are in the range and are in the form of validation lists.

What i would like to do is create an automated summary of who picked what at
the close of each week, which i can email out to the guys in the competiton -

i.e: Event 1: New York Mets: persons a, b, c, d and l , Cleveland: e, f, g,
h, i, j and m

I have 8 events per week, with a number of options per event, thus it is not
easy or quick to just manually do it!

Any suggestions gratefully received!

Cheers!

Hi!

I have a file that I use to run a weekly NFL pick 'em contest.

It sounds just like what you have except I have the "events" (games) listed
on the right and then another column with a drop down to enter the winner.

The players names are listed across the top and in the column under each
players name is another drop down that I use to enter that particular
players picks for that week. I then calculate each players record and
winning percentage for each week.

I do this for each week then I post the results to a website.

If you'd like a copy to see if you can use it for your situation post an
email address and I'll contact you.

Biff

"Blobbies" wrote in message
...
I have a range of data, which is a weekly sports picking competition at
work.

Basically on the left it has the event, and along the top it has my work
colleagues names.

The sports picks are in the range and are in the form of validation lists.

What i would like to do is create an automated summary of who picked what
at
the close of each week, which i can email out to the guys in the
competiton -

i.e: Event 1: New York Mets: persons a, b, c, d and l , Cleveland: e, f,
g,
h, i, j and m

I have 8 events per week, with a number of options per event, thus it is
not
easy or quick to just manually do it!

Any suggestions gratefully received!

Cheers!

hi biff

sounds very similar - yes i would be interested in seeing how you've done it.

i would also be interested in how you get the players picks in, and how you
go about publishing them on a web site.

those sorts of things are way beyond me!!

my players email me a small spreadsheet with each weeks picks - but that is
quite time intensive for me to prepare every week - same with the results,
and i also post out everyone's weekly choices too, so they can see how
they're getting on during the week!

lots of time involved, but fun!!

my email is: mike (at) cherries.co.nz

thanks for your time to answer!


eddie





"Biff" wrote:

Hi!

I have a file that I use to run a weekly NFL pick 'em contest.

It sounds just like what you have except I have the "events" (games) listed
on the right and then another column with a drop down to enter the winner.

The players names are listed across the top and in the column under each
players name is another drop down that I use to enter that particular
players picks for that week. I then calculate each players record and
winning percentage for each week.

I do this for each week then I post the results to a website.

If you'd like a copy to see if you can use it for your situation post an
email address and I'll contact you.

Biff

"Blobbies" wrote in message
...
I have a range of data, which is a weekly sports picking competition at
work.

Basically on the left it has the event, and along the top it has my work
colleagues names.

The sports picks are in the range and are in the form of validation lists.

What i would like to do is create an automated summary of who picked what
at
the close of each week, which i can email out to the guys in the
competiton -

i.e: Event 1: New York Mets: persons a, b, c, d and l , Cleveland: e, f,
g,
h, i, j and m

I have 8 events per week, with a number of options per event, thus it is
not
easy or quick to just manually do it!

Any suggestions gratefully received!

Cheers!

Biff, I would be interested in seeing your spreadsheet. I am trying to create
one for the guy here that runs it and I just can't think of a good way.

Thanks

"Biff" wrote:

Hi!

I have a file that I use to run a weekly NFL pick 'em contest.

It sounds just like what you have except I have the "events" (games) listed
on the right and then another column with a drop down to enter the winner.

The players names are listed across the top and in the column under each
players name is another drop down that I use to enter that particular
players picks for that week. I then calculate each players record and
winning percentage for each week.

I do this for each week then I post the results to a website.

If you'd like a copy to see if you can use it for your situation post an
email address and I'll contact you.

Biff

"Blobbies" wrote in message
...
I have a range of data, which is a weekly sports picking competition at
work.

Basically on the left it has the event, and along the top it has my work
colleagues names.

The sports picks are in the range and are in the form of validation lists.

What i would like to do is create an automated summary of who picked what
at
the close of each week, which i can email out to the guys in the
competiton -

i.e: Event 1: New York Mets: persons a, b, c, d and l , Cleveland: e, f,
g,
h, i, j and m

I have 8 events per week, with a number of options per event, thus it is
not
easy or quick to just manually do it!

Any suggestions gratefully received!

Cheers!