Hello guys!
I have been wandering - how to make formula for lottery number generator...
So what i have in mind
How to create formula that gives all possible results (combinations) of 6 numbers in a range 1-48
Maximum 4 numbers can be consecutive.
I know that it should be easy but I couldn't get further than RANDBETWEEN function with my brains...
Maximum 4 numbers can be consecutive is going to be hard to guarantee but its easy enough to generate 6 numbers just use rand ansd small or large with index match
all combinations on your sheet and if you did what could you do with such info? there are
12,271,512 combinations well less the consecutive ones
Last edited by martindwilson; 12-07-2013 at 12:23 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks