generate unique random numbers

One way ..

Suppose serial nos (1,2,3 ... 600)
and names are in cols A and B, from row1 to 600

Put in C1: =INDEX($A$1:$A$600,RANK(D1,$D$1:$D$600))
Put in D1: =RAND()
Select C1:D1, fill down

C1 returns the random shuffle of the serial nos that's required
Press F9 key to regenerate
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Stephen Larivee" <lariveesl@yahoo.com> wrote in message
news:JNCdndZSyIiKJ7TZnZ2dnUVZ_vSdnZ2d@comcast.com...
> I have a list of 600 names. I would like to generate a random number
> between 1 and 600 for each person but not have any repeating numbers. So
> far I have used
> =rand()*600
> This give me the correct number range but many of the numbers repeat.
>
> Can I accomplish what I want to do?
>
>

Thank you!!!!! I will give it a try.


"Max" <demechanik@yahoo.com> wrote in message
news:%23RrnNorUGHA.5184@TK2MSFTNGP10.phx.gbl...
> One way ..
>
> Suppose serial nos (1,2,3 ... 600)
> and names are in cols A and B, from row1 to 600
>
> Put in C1: =INDEX($A$1:$A$600,RANK(D1,$D$1:$D$600))
> Put in D1: =RAND()
> Select C1:D1, fill down
>
> C1 returns the random shuffle of the serial nos that's required
> Press F9 key to regenerate
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Stephen Larivee" <lariveesl@yahoo.com> wrote in message
> news:JNCdndZSyIiKJ7TZnZ2dnUVZ_vSdnZ2d@comcast.com...
>> I have a list of 600 names. I would like to generate a random number
>> between 1 and 600 for each person but not have any repeating numbers. So
>> far I have used
>> =rand()*600
>> This give me the correct number range but many of the numbers repeat.
>>
>> Can I accomplish what I want to do?
>>
>>
>
>

You're welcome !
Let us know how it went ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Stephen Larivee" <lariveesl@yahoo.com> wrote in message
news:eKadnTu0N_BXI7TZRVn-pA@comcast.com...
> Thank you!!!!! I will give it a try.

Tried it but all of the numbers are either 0 or 1. Where did I go wrong???


"Max" <demechanik@yahoo.com> wrote in message
news:%23RrnNorUGHA.5184@TK2MSFTNGP10.phx.gbl...
> One way ..
>
> Suppose serial nos (1,2,3 ... 600)
> and names are in cols A and B, from row1 to 600
>
> Put in C1: =INDEX($A$1:$A$600,RANK(D1,$D$1:$D$600))
> Put in D1: =RAND()
> Select C1:D1, fill down
>
> C1 returns the random shuffle of the serial nos that's required
> Press F9 key to regenerate
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Stephen Larivee" <lariveesl@yahoo.com> wrote in message
> news:JNCdndZSyIiKJ7TZnZ2dnUVZ_vSdnZ2d@comcast.com...
>> I have a list of 600 names. I would like to generate a random number
>> between 1 and 600 for each person but not have any repeating numbers. So
>> far I have used
>> =rand()*600
>> This give me the correct number range but many of the numbers repeat.
>>
>> Can I accomplish what I want to do?
>>
>>
>
>

My mistake. I made an error in the formula. I corrected it and it seems to
be doing just what I wanted. Thank you very much.



"Max" <demechanik@yahoo.com> wrote in message
news:%23RrnNorUGHA.5184@TK2MSFTNGP10.phx.gbl...
> One way ..
>
> Suppose serial nos (1,2,3 ... 600)
> and names are in cols A and B, from row1 to 600
>
> Put in C1: =INDEX($A$1:$A$600,RANK(D1,$D$1:$D$600))
> Put in D1: =RAND()
> Select C1:D1, fill down
>
> C1 returns the random shuffle of the serial nos that's required
> Press F9 key to regenerate
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Stephen Larivee" <lariveesl@yahoo.com> wrote in message
> news:JNCdndZSyIiKJ7TZnZ2dnUVZ_vSdnZ2d@comcast.com...
>> I have a list of 600 names. I would like to generate a random number
>> between 1 and 600 for each person but not have any repeating numbers. So
>> far I have used
>> =rand()*600
>> This give me the correct number range but many of the numbers repeat.
>>
>> Can I accomplish what I want to do?
>>
>>
>
>

Glad to hear that, Stephen !
Thanks for feeding back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Stephen Larivee" <lariveesl@yahoo.com> wrote in message
news:PaidnVt3NbPsX7TZnZ2dnUVZ_tydnZ2d@comcast.com...
> My mistake. I made an error in the formula. I corrected it and it seems
to
> be doing just what I wanted. Thank you very much.