Random Selection
Use the list of numbers you have, in an adjacent column put the =RAND()
formula, copy down so all values in the list has an adjacent rand value,
select
both columns and sort by the rand column, select the first 40 values from
the list
--
Regards,
Peo Sjoblom
(No private emails please)
"Cris" wrote in message
...
I have a list of numbers that I need Excel to randomly pick 40 of. I can't
use the RAND function because these numbers don't increment by one all the
time. Any ideas how Excel can give me this list?
Thanks!
|