how to generate series of random numbers which are all unique

J

jyoti

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.
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique Random Numbers 2
random number generation help 3
Need to generate unique serial numbers using algorithm 2
Generate list of unique random integer values? 5
How to draw a raffle ticket? 3
How to sum cells based on conditions 2
MACRO RUN random percentage and copy of column values 1
Random generation of employee assignments 5

Top