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