Substitute $A:$A with the column that contains the values and $A2:$A397 with
the range in that column that you want to extract from. Then copy it down
until you have 10 rows. Press F9 when you want to regenerate the list.
See the "Random Elements From A Range Of Worksheet Cells" section at www.cpearson.com/Excel/RandomNumbers.aspx . This returns an array of N
random non-duplicated elements from a range on a worksheet. You can use the
result array in another VBA procedure or you can array enter the formula
into another range on a worksheet.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting www.cpearson.com
(email on the web site)
With the names in A1:A100
in B1: =INDEX($A$1:$A$100,RAND()*100)
copy down to B100
Unfortunately this can result in duplicates
Use the unique random number generator for http://www.mrexcel.com/archive2/75000/87041.htm
Be careful, it puts its results in column A
best wishes
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.