Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Random Lottery Combinations

0

Good day,

I am new to TeachExcel and need some help. I am starting a Lotto Club and need to generate random lotto numbers (6/52).

I have tried a few number generators that work, but are unable to verify if there is a duplicate combination already generated. I also tried code to generate all possible lotto numbers, but it give me the numbers in sequence.

I need generate 10 000 000 lotto numbers with no duplicate combinations.

If anyone can assist me, it would be highly appreocted.

Thank you.

Man On Fire

Answer
Discuss

Discussion

I guess you might be interested in this tutorial.
Chhabi Acharya (rep: 111) May 9, '18 at 10:35 am
Definitely, the way to go aobut this is to look at what you already have and eliminate the features from that which you don't like. Starting from scratch every day, seven days a week, will not assure progress.
Variatus (rep: 4889) May 9, '18 at 8:45 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login