| 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 | |||
Linear Mode
