Pick a Random name from a list.
Insert a column (A) with a sequential number for each individual starting at 1
Then type the follwing formula in a cell :
=VLOOKUP(RAND()*MAX(A:A)+1,A:B,TRUE)
This assumes that you have the names in culumn B
This formula will pick up a random individual, but remember that it changes
everytime you open or recalculate your spreadsheet !!! Winners might quickly
become losers !!!!
Hans
"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?
|