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
 

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

What is this called in Excel or how it works? 0
Influencing Random Numbers 1
Using "=randbetween" to select a number from a range of cells 4
Influencing RandBetween 3
In Excel How Do I Random a Number but Not when it recalculates? 4
Need formulas for searching for a value in a table and returning row/column name 7
Referencing External files with slightly different names 4
Return Names From List 2

Top