randomize set of numbers

[justintime]

Hi!

Column A contains a set of 50, non repeating numbers in random order.

Is there a way to have Excel randomly pick 5 of those numbers, not
repeating its choosing, and display them across a row beginning in
column C?

Thanks!

 

[prahladpriya]

Assuming you have your numbers A1 to A50, you can enter the following
formula in in columns C onwards
=INDEX($A$1:$A$50,IF(ROUNDUP(RAND()*50,0)=0,1,ROUNDUP(RAND()*50,0)))

With every recalculate event (Press F9) the result will change.

-Pramathesh

=m

 

[bplumhoff]

Hello,

I suggest to use my function UniqRandInt:
http://www.sulprobil.com/html/uniqrandint.html

HTH,
Bernd

 

[Jim Cone]

As they are in random order, just pick the top five.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"justintime"
<[email protected]>
wrote in message
Hi!
Column A contains a set of 50, non repeating numbers in random order.

Is there a way to have Excel randomly pick 5 of those numbers, not
repeating its choosing, and display them across a row beginning in
column C?
Thanks!