Random Select one of two or more numbers
 

Hi,
Is there a way that I can randomly select one number from a set of two
or more numbers.eg If I wanted to select one number from the set
3,6,8,15.;)


--
mark_varney47
------------------------------------------------------------------------
mark_varney47's Profile: http://www.excelforum.com/member.php...nfo&userid=333
View this thread: http://www.excelforum.com/showthread...hreadid=561526

Random Select one of two or more numbers
 

=CHOOSE(INT(RAND()*4)+1,3,6,8,15)

HTH
--
AP

"mark_varney47"
a écrit dans le message de news:
...

Hi,
Is there a way that I can randomly select one number from a set of two
or more numbers.eg If I wanted to select one number from the set
3,6,8,15.;)


--
mark_varney47
------------------------------------------------------------------------
mark_varney47's Profile:
http://www.excelforum.com/member.php...nfo&userid=333
View this thread: http://www.excelforum.com/showthread...hreadid=561526

Random Select one of two or more numbers
 

Hi,
Is there a way that I can randomly select two, three or more number
from a row containing 10 numbers

It will be appreciated for your sooner reply

--
jollycarrie
-----------------------------------------------------------------------
jollycarrier's Profile: http://www.excelforum.com/member.php...fo&userid=3769
View this thread: http://www.excelforum.com/showthread.php?threadid=56152