Amber
Could you provide some details about what you are trying to do. As
regards your question, do you want to manually select cells in a random
order or do you want Excel to do so in some automatic way? HTH Otto
Otto,
I have a list of employees who need to get drug tested on a random basis. I
wanted to know if Excel has a function of randomly selecting a certain number
or percent of people from the list.
Amber
Use two columns. In the first column place all the employee names. In
the first cell of the second column type "=Rand()" without the quotes. Note
that "()" is an open parentheses followed by a closed one. Sort the two
columns with the Rand() column the key column. This sorts the employee
names in a random order. If you want to select 15 employee names, simple
take the first 15 names. HTH Otto
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.
