One way is to use a formula like this on 10 cells of the same sheet with the
names:
=INDIRECT("A" & INT(RAND()*800)+1)

Where 800 can be changed to the actual number of rows. Every time you
calculate (F9) it will show a different set of values extracted from column A
(they can repeat, there is no mechanism with this formula to prevent it).
Remember to copy and paste values if you use it, as it will change every time
the sheet is calculated.

Hope this helps,
Miguel.

"DD" wrote:

I have an excel spreadsheet with 800+ names. I need to do a random drawing
to select 10 names for a prize. What is the easiest way to do this?