# Help setting up an office lotto pool.

#### JohnPerk

##### New Member
What I am trying to do is set up a pool at my job where everyone buy's lotto tickets. The numbers from those tickets get put into one sheet. Then when the lottery numbers come out twice a week those numbers will be matched up against the numbers on there tickets automatically. I already have the sheet set up, all I need is the formulas that will allow me to (A.)first figure out how many numbers each person's ticket matched progressively throughout the whole month. That would mean that there are 8 sets of 5 numbers throughout the month (40 numbers)that have to be checked on every persons set of 5 numbers. AND (B.) second returt those people who are in the lead. If you could help me I would graetly appreciate it. If you need more info, or you would like to see what I have so far please let me know. I would really like to get this thing started. Also this is my first post, so if I did anything wrong I am sorry. Thank you for all your help. JOHN PERK

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Welcome to the board!

Can you post a sample of what you have so far? (Click on "Download Colo's HTML Maker..." at the bottom of this page)

this looks more like some sort of bingo. What are the conditions for a player to win? How do you score points?

Finally I got part of the sheet on the forum. What I need is a formula to look up and compare the numbers from C12:G12 against the numbers in C2:G9 and have that formula which will give me the number of matches put in the matches column. By just putting in the numbers twice a week

The player has to be the first to get all 5 of his numbers, so in that respect it is just like bingo, but, we are using the lotto numbers instead of balls. No points really, just first to win gets bragging rights.

=COUNTIF(C2:G9,C12)+COUNTIF(C2:G9,D12)+COUNTIF(C2:G9,E12)+COUNTIF(C2:G9,F12)+COUNTIF(C2:G9,G12)

I have an idea that this formula can be written slightly shorter, but I'm not sure how

Also, beware that you can use a number only once in C2:G9, or it will be count twice

Thank you harvey, but I have no controll over what numbers come out. Is there any way that I can avoid this problem?

Replies
1
Views
156
Replies
1
Views
420
Replies
0
Views
111
Replies
3
Views
143
Replies
7
Views
244

1,221,206
Messages
6,158,515
Members
451,497
Latest member
something68

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back