With the names in A1:A100
in B1: =INDEX($A$1:$A$100,RAND()*100)
copy down to B100
Unfortunately this can result in duplicates
Use the unique random number generator for
http://www.mrexcel.com/archive2/75000/87041.htm
Be careful, it puts its results in column A
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Heather" wrote in message
...
I am looking to randomly select people from a list created in Excel. An
example would be I have 100 people and I want to randomly select 10% of
them.