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

user_11462274 0
Viewed 16415

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

Here is the simplest way to do this.

google-sheets-formula google-sheets indexing random
2 Answers

one character shorter solution would be:

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

0

user_56326290

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.

user_114622740
Related