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

Originally Posted by 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

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

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

Not that I know of.