| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with excel array - select, add and calculate result | Excel Worksheet Functions | |||
| Help with Excel array functions - select, add & return result | Excel Worksheet Functions | |||
| sheets(array).select problem | Excel Discussion (Misc queries) | |||
| Select sheets from an array for printing | Excel Discussion (Misc queries) | |||
| Error 1004 using array in Sheet select. | Excel Discussion (Misc queries) | |||
Linear Mode
