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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can the computer be set to randomly select a row for a drawing? (https://www.excelbanter.com/excel-discussion-misc-queries/21162-can-computer-set-randomly-select-row-drawing.html)

annie33

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

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

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.

"annie33" wrote:

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

All times are GMT +1. The time now is 04:31 AM.