how to generate series of random numbers which are all unique

  • Thread starter Thread starter jyoti
  • Start date Start date
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.
 
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

Sub to stack data n paste unique order ID lines 3
Sub to carve out uniques based on col header whose position may va 6
random number generation help 3
Sorting rows out of order after all rows are numbered in sequence 1
Random selection of records based on specifc value 5
Unique Random Numbers 2
Formula to choose X number of unique random cells from array? 5
select columns to create new workbook 9

Back
Top