You could use something like this:

=LARGE(A1:A10,RANBETWEEN(1,10))

This returns the nth largest number from the given range, where n is
randomly selected from 1 to the number of fields in your range.

HTH,
Elkar


"JMRamsey" wrote:


Does anyone know how to randomly select a number from a column. I would
like to randomly select from a given field, not a random number between
two numbers. Thanks


--
JMRamsey
------------------------------------------------------------------------
JMRamsey's Profile: http://www.excelforum.com/member.php...o&userid=32799
View this thread: http://www.excelforum.com/showthread...hreadid=526212