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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I will be entering in a whole list of names from various locations for a
drawing. How can I ramdomly select a registered winner?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need formula help 4
Lucky Draw 2
Save RAND select number 3
the formula for random selecting 2
Select A Random Cell From A Defined Range No Dups 2
Can Excel randomly pick one winner out of 100 contest entries? 4
How can I randomly sort a column of data using Excel? 2
Weighted Random Selection 5

Back
Top