how do i select in aleatory way 3 numbers from an array of 10

  • Thread starter Thread starter Guest
  • Start date Start date
Mauro --

Which three? If you're trying to select on the fly, you can select the
first one, then hold down the ctrl key while you click the second and then
the third. If you're trying to have Excel select three, we need to know
which three you want...
 
Selection with replacement? Something like...

=INDEX($A$1:$A$10, INT(10*RAND())+1)

=INDEX({1,2,3,4,5,6,7,8,9,10}, INT(10*RAND())+1)

- David
 
mauro said:
i have an array of ten numbres and i want to select 3 of these numbers
Click to expand...

Assume numbers listed in A1:A10

Put in B1: =RAND()
Copy down to B10

Put in C1: =INDEX(A:A,RANK(B1,B$1:B$10))
Copy down to C3. C1:C3 will return a random selection of 3 items from the
source list in A1:A10. Press F9 to regenerate.

---
 
Back
Top