Is there a way to show just the random name graphically and make this
automatic for a daily drawing that takes place at a set time daily.

"Jerry W. Lewis" wrote:

If there are 1700 names in column A in cells A1:A1700, then
=OFFSET(A1,INT(1700*RAND()),0)
should do the job.

Jerry

"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?