View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] prahladpriya@gmail.com is offline
external usenet poster
 
Posts: 2
Default randomize set of numbers

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,ROUN DUP(RAND()*50,0)))

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

-Pramathesh

=m
justintime wrote:
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!