random winner

  • Thread starter Thread starter wagergirl
  • Start date Start date
W

wagergirl

does anyone know how to have excel pick a a cell and row
at random to find a winner for a drawing. We are getting
feedback for a survey and the ones that provide their
email addresses are eligible. thanks
 
Hi
if you want to pick a winner for rows 1:10 and columns A:F try the
following formula
=INDEX(A1:F10,RANDBETWEEN(1,10),RANDBETWEEN(1,6))
 
Another approach to play around ?

Assuming your list of qualifiers
is in Sheet1, row2 downwards,
viz. the sample set below:

Name Field1 Field2 etc ..
ABC
DEF
XYZ
etc

Put in say A1 in a new Sheet2:

=OFFSET(Sheet1!$A$1,randbetween(1,COUNTA(Sheet1!A:A)-1),0)

A1 will return a random winner (i.e. a name)
from amongst those listed in Sheet1's col A (the qualifiers)

You could hold down F9 to visually "simulate" the spinning
of the draw and then release F9 after say 10 seconds

The winner will be the name appearing in A1 ..
 
Back
Top