Generating Random Number from a set of numbers
 

Hello,

I need to generate a set of 12 random numbers from given numbers 1--24 and I
only want to generate 12 even numbers. Any idea as to how I do this?

thanks

Generating Random Number from a set of numbers
 

CalsLib Wrote:
Hello,

I need to generate a set of 12 random numbers from given numbers 1--24
and I
only want to generate 12 even numbers. Any idea as to how I do this?

thanks


Is RANDBETWEEN(1,12)*2 what you want?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=523309

Generating Random Number from a set of numbers
 

Yeah, I think it will work; however, is there a way to use Tools Data
Analysis random number generation to do the same thing?

But, yes, that's great, thanks.

"Morrigan" wrote:


CalsLib Wrote:
Hello,

I need to generate a set of 12 random numbers from given numbers 1--24
and I
only want to generate 12 even numbers. Any idea as to how I do this?

thanks


Is RANDBETWEEN(1,12)*2 what you want?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=523309

Generating Random Number from a set of numbers
 

Not that I know of.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=523309