View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Allllen[_2_] Allllen[_2_] is offline
external usenet poster
 
Posts: 13
Default random select a percentage from a list

=RAND()
gives you a number between 0 and 1

=RAND()*891
will give you a number between 0 and 891

You can round it to the nearest 1 with
=ROUND(RAND()*891,0)

If you only want to look at 10% of the 891, you can use
=ROUND(RAND()*891*0.1,0)
which will give you a number from 0 to 89.

It is not clear exactly what you mean but i think you'll get what you need
from what I have written.
--
Allllen


"Rocetman" wrote:

I am trying to randomly select a percentage from a list of 891 for
assessment interviews. Do I use Rand ()*.1 for 10 percent of the selection?