wheeling numbers
 

hi all

is it possible to get excel to wheel all lotto numbers (1 to 49)
and save them to excel??

tks
António

One way

put 1 and A1 2 in A2 and so on down to 49 in A49 in B1, put =RAND()
copy down the formula to B49, select both column and do datasort and sort
ascending
by column B, now select the 7 first numbers.

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Antonio" wrote in message
...
hi all

is it possible to get excel to wheel all lotto numbers (1 to 49)
and save them to excel??

tks
António

Hi
Your reply, this gives me random combinations, done
manualy, and not an automatic number generator.
Tks n rgds
António


"Peo Sjoblom" wrote:

One way

put 1 and A1 2 in A2 and so on down to 49 in A49 in B1, put =RAND()
copy down the formula to B49, select both column and do datasort and sort
ascending
by column B, now select the 7 first numbers.

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Antonio" wrote in message
...
hi all

is it possible to get excel to wheel all lotto numbers (1 to 49)
and save them to excel??

tks
António

Press your F9 function key continually and watch Col B!!

"Antonio" wrote in message
...
Hi
Your reply, this gives me random combinations, done
manualy, and not an automatic number generator.
Tks n rgds
António


"Peo Sjoblom" wrote:

One way

put 1 and A1 2 in A2 and so on down to 49 in A49 in B1, put =RAND()
copy down the formula to B49, select both column and do datasort and
sort
ascending
by column B, now select the 7 first numbers.

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Antonio" wrote in message
...
hi all

is it possible to get excel to wheel all lotto numbers (1 to 49)
and save them to excel??

tks
António

Perhaps you might want to try this play ..

Put in A1: =RAND()
Copy down to A49

Select an adjacent range B1:B49

Put in the *formula bar*: =RANK(A1:A49,A1:A49)

Array-enter the formula,
i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER

B1:B49 will return a non-repeating randomized
scramble of the numbers 1 - 49

Just press F9 key to recalc a fresh scramble !

And if desired, we could extract and re-lay**
the numbers in B1:B49 into a 7 x 7 grid
say, in D1:J7
**Numbers arranged in a zig-zag manner

Put in D1:
=OFFSET($B$1,ROW(A1)*7-7+COLUMN(A1)-1,)
Copy D1 across to J1, fill down to J7

D1:J7 returns 7 sets of 7 random numbers
"horizontally" and another 7 sets "vertically"
and 2 sets diagonally (Total: 16 sets <g)

Again, just tap / press F9 key
to "wheel" a fresh scramble in D1:J7 !

Freeze the results elsewhere as needed
with a copy paste special values

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Antonio" wrote in message
...
Hi
Your reply, this gives me random combinations, done
manualy, and not an automatic number generator.
Tks n rgds
António