|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Random Selection
One way:
http://www.mcgimpsey.com/excel/udfs/...noreplace.html
In article ,
Craig wrote:
Hello all,
I am attempting to generate a random group of names from a list and am
having a bit of trouble. In a previous posting I found the formula
=INDEX(A4:A15,INT(RAND()*(12-1)+1)), which is perfect for selecting a single
name. The trouble that I have is that I need a random sample of 20% of the
list. Copying the formula into multiple cells leaves open the chance that
any given name can be selected multiple times.
Does anyone know a way to perform this same function in subsequent cells,
while excluding previously selected names?
Thank you for your help.
Craig
|