Random Number Selection
 

I need to randomly select 20 numbers from a list of 10k. How would I be able
to do this use the Random Generator?

Random Number Selection
 

Put the list in column A and in B1 enter:

=RAND() and copy down

then sort columns A & B by column B. This will shuffle the numbers in
column A.


Just pick the top 20 in column A.
--
Gary''s Student - gsnu200767


"Work.Work.Work" wrote:

I need to randomly select 20 numbers from a list of 10k. How would I be able
to do this use the Random Generator?

Random Number Selection
 

Thanks for the quick reply, but what I am looking for is an auto generator.
Where it takes my list of values and randomly select X amount of numbers and
generate a list for me?

"Gary''s Student" wrote:

Put the list in column A and in B1 enter:

=RAND() and copy down

then sort columns A & B by column B. This will shuffle the numbers in
column A.


Just pick the top 20 in column A.
--
Gary''s Student - gsnu200767


"Work.Work.Work" wrote:

I need to randomly select 20 numbers from a list of 10k. How would I be able
to do this use the Random Generator?

Random Number Selection
 

In addition to what I said about columns A&B, in C1 enter:
=A1 and copy down thru C20

now when you sort columns A&B, column C will automatically have your 20
random picks.
--
Gary''s Student - gsnu200767


"Work.Work.Work" wrote:

Thanks for the quick reply, but what I am looking for is an auto generator.
Where it takes my list of values and randomly select X amount of numbers and
generate a list for me?

"Gary''s Student" wrote:

Put the list in column A and in B1 enter:

=RAND() and copy down

then sort columns A & B by column B. This will shuffle the numbers in
column A.


Just pick the top 20 in column A.
--
Gary''s Student - gsnu200767


"Work.Work.Work" wrote:

I need to randomly select 20 numbers from a list of 10k. How would I be able
to do this use the Random Generator?

Random Number Selection
 

I have a number of VBA functions for random numbers as
http://www.cpearson.com/excel/randomNumbers.aspx


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

"Work.Work.Work" wrote in message
...
Thanks for the quick reply, but what I am looking for is an auto
generator.
Where it takes my list of values and randomly select X amount of numbers
and
generate a list for me?

"Gary''s Student" wrote:

Put the list in column A and in B1 enter:

=RAND() and copy down

then sort columns A & B by column B. This will shuffle the numbers in
column A.


Just pick the top 20 in column A.
--
Gary''s Student - gsnu200767


"Work.Work.Work" wrote:

I need to randomly select 20 numbers from a list of 10k. How would I be
able
to do this use the Random Generator?