Lottery Syndicate Manager

Mr B G

New Member
Joined
Nov 30, 2009
Messages
8
Hello!

I am just about to begin being in charge of a lottery syndicate. It's for the UK Lotto if that makes any difference.

I am looking for a nifty spreadsheet that I can enter the 6 winning numbers into and have it tell me if we have matched any numbers against our lines.

I have tried to do this myself, but failed - badly.

If anyone knows what the sum is in excel that would be great. I can make it look pretty later ;)

So to summarise; we have 13 lines of 6 numbers and I want to enter the weekly drawn numbers and have it highlight if we have any matches.

Any help would be great!

Thanks alot!!!!
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
Hi, welcome to the board.
Here's one way.
Let's say you plug the winning numbers into cells A1:F1.

Let's say one of your entries is in A2:F2.
Code:
=if(iserror(hlookup(a2,$a$1:$f$1,1,false)),"N","Y")
will tell you if the first digit for your entry was part of the winning numbers.
Repeat this formula 5 more times for each entry.
You'll end up with something like this
Winning number 1 2 3 4 5 6
Your first entry 5 6 7 8 9 10 Y Y N N N N
 

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
Dim c1 As Range, rng1
Dim c2 As Range, rng2
Dim chkval As Integer

Set rng2 = Range("a1:F13")
Set rng1 = Range("a16:f16")

For Each c1 In rng1
chkval = c1.Value
For Each c2 In rng2
If c2.Value = chkval Then
c2.Interior.ColorIndex = 7
End If
Next c2
Next c1
 

BIGD73

New Member
Joined
Nov 14, 2017
Messages
1
Hi I was interested if anybody could assist with a template for a lottery syndicate manager spreadsheet please?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,158
Messages
5,600,054
Members
414,357
Latest member
Gemma_R

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top