Pick a Random name from a list.

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?

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?

Thanks I will give it a Try!

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

Thanks I will give it a Try!

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

Thanks I will give it a Try!

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