Lottery pool template

A buddy of mine is looking to start some sort of lottery pool at his place of work. I told him he should use excel to keep track of everyone's numbers so he doesn't have to spend 24 hours looking through the number himself. He doesn't know much about computers so I told him that I would set him up with a template he can use to fill in everyone's names and numbers. I'm great with computers, but I have 0 experience with excel. I've always had excel but never bothered to open it, as I have never needed it before. I can't seem to find any templates that will accomplish what he is trying to do and since I don't use excel I can't figure out how to make one. Any how-tos would be greatly appreciated.

The layout seems fairly simple. Everyone's names on the left, and the 10 numbers they pick on the right. The main question I have is, how do you input the 6 numbers that get drawn in the lottery and have excel search and blank out all the inputted numbers as to keep track of who has the most. And how do you have excel re-arrange the players so that the person with the most amount of numbers hit is all the way on the top?

I know that these kinds of posts can be very annoying to most people and I may have broke a few hundred forum rules, and for that I apologize.

The range is 1-52

Hi Catman,
see this if its help.
sem

Sem, that's not bad. I figured out how to sort them, but I can't figure out how to input more data. How to you add another set of numbers that had been drawn?

Originally Posted by martindwilson

here you go
but i dont understand what you mean by enter more data this is draw by draw

That's pretty awesome. I like the touch of red you added.

What I mean is, I don't know how to add more numbers the draw section. How do I add another 6 numbers to this?

Originally Posted by martindwilson

thats the cumulative version tab 1 is to check a week tab 2 works out total this assumes once someones ten numbers are picked they stay fixed until a certain target has been reached it is set up for 58 weeks
you must have seen it before i put up the edited version

Ah, Indeed I did. That's very well done and you seemed to do it rather quickly. This is exactly what I have been trying to figure out. I'm going to play around with this template for a while and see if I can get set up the way he wants it. I'm going to try to figure out how you did all this on my own, but I'm sure I'll be back with more questions. Thanks again.

Do the two tabs work together. I want the running numbers each week to highlight the tab 1 sheet when they are entered every week.. Thanks..

Here is a great Powerball pool manager that I am using. You can add more bells and whistles, but it does a great job as is. The yellow fields are calculated and are locked with no password if you want to see what I did or make changes

Hi can anyone help me with this also