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

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

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

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

"mauro" wrote:

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

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

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 wrote:
i have an array of ten numbres and i want to select 3 of these numbers, how
can i do?

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

"mauro" wrote:
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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---