View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Stephen Larivee
 
Posts: n/a
Default generate unique random numbers

I have a list of 600 names. I would like to generate a random number
between 1 and 600 for each person but not have any repeating numbers. So
far I have used
=rand()*600
This give me the correct number range but many of the numbers repeat.

Can I accomplish what I want to do?