How to generate random number each time?

In 6/49 lotto system:Is there a way (on excel) that I can generate 6 number combos for a set group of numbers?

  • I need to be able to generate all possible number combinations for a maximum of 12 numbers at any given time. Please help...

  • Answer:

    Enter 1 to 49 in col A In B1 enter =RAND() and copy down to row 49 In C1 enter =INDEX($A:$A, MATCH( SMALL(B:B,ROWS($1:1)), B:B,0))) copy down to row 6 This will give you the first 6/49 group. Copy col B & C across for the second and subsequent random groups You may want to turn off Autocalculate to stop number changes it you type anything. Press F9 to recalculate the next set(s).in cols E, G, I etc May want to hide cols B, D, F etc to make it easier to read.

IXL@XL at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

IXL@XL told you what you wanted to know. "Best Answer" there, obviously. With that said, NONE of this is going to do you any good. You have fooled yourself, (or someone else fooled you), into thinking this will increase your chances at winning. It won't. The only thing this will do is to cause you to waste even more money down the drain on lottery tickets.

pdq

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.