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?
|