Re: Randomly selected numbers

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It will really work better if all the numbers are included when you copy
down the formula.

Forgot to anchor the references with absolutes.

Use this:

=INDEX(ROW($A$1:$A$49),RANK(Z1,$Z$1:$Z$49),$Z$1:$Z$49)
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"RagDyeR" <ragdyer@xxxxxxxxxxxxx> wrote in message
news:OfiLlHQQFHA.1268@xxxxxxxxxxxxxxxxxxxxxxx
Since you say this is for a lottery, I guess you'll be using it quite often.

This procedure will allow you to display a new set of numbers each time you
hit the <F9> key.

First, you have to enter the RAND() function in a column, and then refer to
that column with a formula.

Say you use Column Z.
Enter
=RAND()
in Z1, and copy down to Z49.

Then, place this formula anywhere, and copy it down as many rows as you wish
to display your random numbers:

=INDEX(ROW(A1:A49),RANK(Z1,Z1:Z49),Z1:Z49)

Now, every time you hit the <F9> (calculate) key, you'll get a new random
display.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Keith Robinson" <Keith.Robinson28@xxxxxxxxxxxx> wrote in message
news:IUt7e.13199$C2.4427@xxxxxxxxxxxxxxxxxxxxxxx
Hi
How can I randomly select six different numbers at any one time i.e lottery
numbers. I have tried using the formula
=INT(RAND()*49)+1, which works OK but I get repeated numbers, can anyone
help?
Keith





.

Relevant Pages

  • Re: Randomly selected numbers
    ... Since you say this is for a lottery, I guess you'll be using it quite often. ... This procedure will allow you to display a new set of numbers each time you ... First, you have to enter the RAND() function in a column, and then refer to ... Now, every time you hit the key, you'll get a new random ...
    (microsoft.public.excel)
  • Re: POWDER 103 Released
    ... Especially since the display implies it is simple. ... So there is a hidden hit location system. ... Consider a character with two armour slots, ... which is the same as the plate with no helmet. ...
    (rec.games.roguelike.misc)
  • Re: Words / Lines overlap after hitting Enter within a table in Wo
    ... It's just a display issue. ... > Or is Word really inserting extra text into the table? ... When I hit ... >> to explain this problem unless someone sees the actual screenshot of this ...
    (microsoft.public.word.docmanagement)
  • RE: ws3svc
    ... Click on the Magnifying glass at the top or hit Ctrl+ E, ... Click on Edit-> Clear Display or hit Ctrl+X to clear the display. ... 5)Once the display is clear in Filemon window, hit Ctrl+E to start capture. ... Search for Access Denied and you will find if a particular user account ...
    (microsoft.public.inetserver.iis)
  • Re: Words / Lines overlap after hitting Enter within a table in Word!!
    ... It's just a display issue. ... Or is Word really inserting extra text into the table? ... When I hit ... > to explain this problem unless someone sees the actual screenshot of this ...
    (microsoft.public.word.docmanagement)