ROUND(RAND()*10,0)

That will generate random numbers from 0 to 10 and could lead to an error or
a non-random result depending on where the formula is entered.

Try this:

ROUND(RAND()*9,0)+1

Or this:

RANDBETWEEN(1,10)

This one requires the Analysis ToolPak add-in be installed if using Excel
versions prior to Excel 2007.

--
Biff
Microsoft Excel MVP


"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
You can use =Rand() to generate a random number then use that to find a
value
from the list...

If you have 10 values in the list and your list is in C1:C10 then use
=INDEX(C1:C10,ROUND(RAND()*10,0),1)

"JohnB" wrote:

Is there a function for randomly selecting a value from a list of values?