combination of numbers in lottery

[knoertje]

No, not yet. I'm busy truying to get it to work, but it does only a fe
lines of checking. And it takes a long time. But I keep trying. I wi
attach a zip file with what I have so far. I trying to choose between
or 3 or 4 number combinations. For example: I want to find out if 10 an
20 excist in combination with each other. Or if 2 and 12 and 37 exist i
combination with each other. And if they do, how often. Or even a fou
numbered combination. I don't know if it is possible in Excel, bu
that's what I had in mind. And maybe I get there someday. And by th
way.....thanks for the time and effort you have put into it

Attachment filename: testlotto.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=63726

 

[RB Smissaert]

Don't understand.
Have tested comparing a combination of 7 numbers with 35000 other 7 number
combinations.
This took about 1.5 secs. This is on a fast computer, but still.
If you want I send you the workbook.

RBS

 

[knoertje]

It would be nice to take a look at that workbook. As you understand I'
just beginning with Excel and VBA. So learning from some code is alway
a good option

 

[RB Smissaert]

Ok, not sure though what the e-mail address is.

RBS

 

[knoertje]

In this attachment

Attachment filename: test.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=63969

 

[RB Smissaert]

What I mean is I need an e-mail address to send you the file.

RBS

 

[knoertje]

As I don't want to leave my emailadress all over the place, to preven
my mailbox being flooded, I included it in the last attachement
test.zip. There you have to look!!!

 

[RB Smissaert]

I am not keen on downloading attachements!
My e-mail shows in this post (properties), so you
could just mail it to that.

RBS

 

[knoertje]

Yours doen't show either. Anyway: (e-mail address removed)

 

[knoertje]

Well I must thank you for sending this so quickly. It does what I wan
it to do. And in good speed. I'm gratefull for the help. I hope I ca
be of any help sometime.

Thanks again

M

 

[RB Smissaert]

Half of the jackpot will do.

RBS

 

[Tina]

Hello RB Smissaert,

Hope you don't mind me resurrecting this August 2004, Posting from
Excelforum.com/attachment.php?postid=637263 -
regarding "combination of numbers in lottery" dated 8/7/2004. I have a
similar requirement and if you do not mind I would appreciate a copy of the
Excel spreadsheet you created for MJ - knoertje, if still available.

Thanks
Tina

Don't understand.
Have tested comparing a combination of 7 numbers with 35000 other 7 number
combinations.
This took about 1.5 secs. This is on a fast computer, but still.
If you want I send you the workbook.

RBS

 

[Tina]

Hi Bart,

Thanks for file.
Tina

Hello RB Smissaert,

Hope you don't mind me resurrecting this August 2004, Posting from
Excelforum.com/attachment.php?postid=637263 -
regarding "combination of numbers in lottery" dated 8/7/2004. I have a
similar requirement and if you do not mind I would appreciate a copy of the
Excel spreadsheet you created for MJ - knoertje, if still available.

Thanks
Tina