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