someone else will give you a simpler formula, but, if not, the following
will work:

=INDIRECT("A"&ROUND(RAND()*(20-1)+1,0))


"Paul Gupta" wrote in message
om...
Hi, I have never programmed Excel before, but do use it a fair amount,
including use of built-in formulae. I would like to be able to select
a random value among a group of values - is this possible?

So for example, in a spreadsheet I have in column A a list of names
from cell 1 to cell 20. then I want to pick a name from random from
that list. How would I do?

Any input would be appreciated.

-- Paul


PS I do not have visual Studio/VB installed on my machine.