Helene deChappe wrote:
I'm dong a random giveaway and have a huge list of name in an excel sheet. Is
there a way for excel to pick a random cell instead of printing, cutting and
pulling from a hat.

Try one of the following, depending on whether the names are in a
column (first one) or in a row (second one):

=offset(B3,10*rand(),0)

=offset(B3,0,10*rand())

Replace "B3" with the reference to the cell with the first name.
Replace "10" with the number of names -- or use count(B3:B12), where
"B3:B12" is the range that contains all names.

Note that if you use F9 to select more than one name (or if you put the
formula in multiple cells for that purpose), the same name might be
selected multiple times. Also note that if you save and later re-open
the worksheet, you will likely find a different name selected.

If those are problems for you, feel free to post back to ask for
solutions.