Simple way to choose random cell from a list in Google Sheets

Question

Do you have a list of names in one column and want to draw between them?

Here is the simplest way to do this.

Answer 1

one character shorter solution would be:

=INDIRECT("A"&RANDBETWEEN(1,10))

Answer 2

For this we will use two functions: INDEX and RANDBETWEEN

If you want to randomly choose one cell between A1 and A10 the formula would look as follows:

=INDEX(A1:A10,RANDBETWEEN(1,10))

And if you decide to make more than one draw, you can type CONTROL+R, automatically the formula is updated within the cell, delivering a new result.