Lottery Syndicate Manager

[Mr B G]

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!!!!

 

[Gerald Higgins]

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.

=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]

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

 

[lenze]

See Barry's example here.
lenze

 

[BIGD73]

Hi I was interested if anybody could assist with a template for a lottery syndicate manager spreadsheet please?