how to generate series of random numbers which are all unique

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jyoti - 17 Apr 2008 09:14 GMT

I have 2 col , each having certain unique values. I need to re arrange both
the col randomly.

e.g., 1 st col contains unique names and 2nd col contains certain ID's (
numeric/text). I need to assign these ID's randomly to each names.

Reply to this Message

Mike H - 17 Apr 2008 11:07 GMT

Hi,

Put a helper column next to each of your 2 columns of data and put the formula
=Rand()
in each and drag down to the length of your 2 columns
Select the name and helper column and sort on the helper column
Repeat this for the ID#
delete the helper columns
You should now have a completely random association between name & ID.

Mike

> I have 2 col , each having certain unique values. I need to re arrange both
> the col randomly.
>
> e.g., 1 st col contains unique names and 2nd col contains certain ID's (
> numeric/text). I need to assign these ID's randomly to each names.

Reply to this Message