Can the computer be set to randomly select a row for a drawing?

A

annie33

I will be entering in a whole list of names from various locations for a
drawing. How can I ramdomly select a registered winner?
 
J

Jonathan Cooper

lets say your list of names is in row A1:A100. You could type a formula in
B1 that says =RANDBETWEEN(1,100)

keep in mind that the result will change every time you open the file, press
F9 and probably a few other circumstances. So, if you want to save the
result, you'll need to copy/paste values over top of the formula after it
picks the winner.
 
Top