Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

generating random number list

1 view
Skip to first unread message

yvette

unread,
Jan 12, 2007, 11:35:00 AM1/12/07
to
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!


Gary''s Student

unread,
Jan 12, 2007, 12:07:00 PM1/12/07
to
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

0 new messages