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

[Guest]

i have an array of ten numbres and i want to select 3 of these numbers, how
can i do?

 

[Guest]

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

 

[David Hilberg]

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

 

[Guest]

i have an array of ten numbres and i want to select 3 of these numbers

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.

---