Thread: how do i select in aleatory way 3 numbers from an array of 10
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Hilberg David Hilberg is offline
external usenet poster
  
Posts: 84
Default 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?
Reply With QuoteReply With Quote