generating random number list
 

Hi there,

Is there a way to generate a set of random numbers (ie. 200) within a
certain range (ie. 1-500) with no duplicates?

Thanks!

generating random number list
 

Put the original list in column A from A1 thru A500.

Put =RAND() in B1 thru B500

Sort the columns by column B. This "shuffles" the contents of column A.

Use the first 200 items in the "shuffled" column.
--
Gary's Student
gsnu200701


"yvette" wrote:

Hi there,

Is there a way to generate a set of random numbers (ie. 200) within a
certain range (ie. 1-500) with no duplicates?

Thanks!