Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to generate series of random numbers which are all unique
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to generate series of random numbers which are all unique
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 "jyoti" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate random numbers | Excel Discussion (Misc queries) | |||
Generate Random numbers from a pre-defined set | Excel Worksheet Functions | |||
generate unique random numbers | New Users to Excel | |||
Generate random numbers between two values and with a given mean | Excel Worksheet Functions | |||
generate random numbers | Excel Worksheet Functions |