Random Numbers

You can try this:

Enter
=RAND()
In AA1 and drag across to BN1,
Then down to BN10,
So you have a 40 column by 10 row array of random numbers.

Then, enter this formula anywhere you wish:

=INDEX(ROW($A1:$A40),RANK(AA1,$AA1:$BN1))

Now, copy this formula across 6 columns.
Then, copy down 10 rows.

This should give you what you're looking for.
You'll get a new set of numbers with each hit of <F9>.

--
HTH,

RD

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



"Steved" <[email protected]> wrote in message
news:[email protected]...
> Hello Harlan from Steve
>
> I think i'm missing something here
>
> I followed what you put below naming the range PNRA
>
> ok =RAND() are in cell A1:F10 I highlighted and then I
> Insert Name Define
>
> please I am lost where do I put the below
>
>
> COUNTIF(PRNA,"<="&INDEX(PRNA,ROWS($C$5:C5)*6-COLUMNS($C$5:C5)+1))
>
> Also do I change your $C$5:$C$5 to $A$1:$A$1
>
> ok also please what is require to reconize the number between 1 to 40.
>
> Thankyou.
>
> "Harlan Grove" wrote:
>
>> Steved wrote...
>> ....
>> >Can your formula devoloped to display
>> >6 columns across and 10 rows deep please.
>> ....
>> >"Gary''s Student" wrote:
>> >>If you need to randomly select 6 numbers from the range 1-40 with no
>> >>repeats:
>> >>
>> >>1. Enter the numbers 1-40 into an un-used column
>> >>2. Enter =RAND() into the cells of the adjacent column
>> >>3. Sort the two columns by the RAND column
>> ....
>>
>> You don't need steps 1 or 3. All you need is a range of 60 cells (10*6)
>> all containing =RAND(). If that range were named PRNA and the top-left
>> cell of your 10 by 6 result range were C5, enter the following formula
>> in C5.
>>
>> C5:
>> =COUNTIF(PRNA,"<="&INDEX(PRNA,ROWS($C$5:C5)*6-COLUMNS($C$5:C5)+1))
>>
>> Select C5 and fill right into D5:H5. Then select C5:H5 and fill down
>> into C6:H14.
>>
>>

Hello Ragdyer from Steved

Excellent thankyou.

"Ragdyer" wrote:

> You can try this:
>
> Enter
> =RAND()
> In AA1 and drag across to BN1,
> Then down to BN10,
> So you have a 40 column by 10 row array of random numbers.
>
> Then, enter this formula anywhere you wish:
>
> =INDEX(ROW($A1:$A40),RANK(AA1,$AA1:$BN1))
>
> Now, copy this formula across 6 columns.
> Then, copy down 10 rows.
>
> This should give you what you're looking for.
> You'll get a new set of numbers with each hit of <F9>.
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
>
>
> "Steved" <[email protected]> wrote in message
> news:[email protected]...
> > Hello Harlan from Steve
> >
> > I think i'm missing something here
> >
> > I followed what you put below naming the range PNRA
> >
> > ok =RAND() are in cell A1:F10 I highlighted and then I
> > Insert Name Define
> >
> > please I am lost where do I put the below
> >
> >
> > COUNTIF(PRNA,"<="&INDEX(PRNA,ROWS($C$5:C5)*6-COLUMNS($C$5:C5)+1))
> >
> > Also do I change your $C$5:$C$5 to $A$1:$A$1
> >
> > ok also please what is require to reconize the number between 1 to 40.
> >
> > Thankyou.
> >
> > "Harlan Grove" wrote:
> >
> >> Steved wrote...
> >> ....
> >> >Can your formula devoloped to display
> >> >6 columns across and 10 rows deep please.
> >> ....
> >> >"Gary''s Student" wrote:
> >> >>If you need to randomly select 6 numbers from the range 1-40 with no
> >> >>repeats:
> >> >>
> >> >>1. Enter the numbers 1-40 into an un-used column
> >> >>2. Enter =RAND() into the cells of the adjacent column
> >> >>3. Sort the two columns by the RAND column
> >> ....
> >>
> >> You don't need steps 1 or 3. All you need is a range of 60 cells (10*6)
> >> all containing =RAND(). If that range were named PRNA and the top-left
> >> cell of your 10 by 6 result range were C5, enter the following formula
> >> in C5.
> >>
> >> C5:
> >> =COUNTIF(PRNA,"<="&INDEX(PRNA,ROWS($C$5:C5)*6-COLUMNS($C$5:C5)+1))
> >>
> >> Select C5 and fill right into D5:H5. Then select C5:H5 and fill down
> >> into C6:H14.
> >>
> >>
>
>