Generating Random Number from a set of numbers

C

CalsLib

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
 
M

Morrigan

CalsLib said:
Hello,

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

thanks
Click to expand...


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

CalsLib

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.
 
Top