close

I need to generate 12 random (even) numbers from a give set of numbers 1--24.
How do I get excel to do this?

Thanks

=RANDBETWEEN(1,12)*2

Copy down so you have 12 rows

--
Kind regards,

Niek Otten

quot;CalsLibquot; gt; wrote in message ...
gt;I need to generate 12 random (even) numbers from a give set of numbers 1--24.
gt; How do I get excel to do this?
gt;
gt; Thanks

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄