how to return a text from a random row?

G

Gary Thomson

Hi,

I am assuming your list of names appear in A1:A100 (if
not, you'll need to change it so they do, or change the
cell references in the formula).

Now, type in cell B1 (or wherever you want your random
name displayed)

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

Change the 1 and 100 to adjust the number of rows your
names appear in, and adjust the A if the names do not
appear in column A,

Happy to Help,

Gary Thomson
 
Top