Add another column next to the names.

Fill it with this formula:
=rand()

Select both columns and sort by the random number column.

Choose the name that sorts to the top.

Recalculate and sort again if you have to pick another winner.

psells wrote:

Did anyone ever tell you how to do this? I just got 2007 and have no idea now.

"David M Fritzke" wrote:

I am working on a Free Give Away of some products. Our systems give me a
list of individuals who we have had contact which are then placed in excel.
We would like to pick a weekly winner and would prefer not to throw darts at
my screen. Any Ideas?

--

Dave Peterson