View Single Post
  #6   Report Post  
JE McGimpsey
 
Posts: n/a
Default

No. When array-entered, the function returns the same number of ints as
cells.

Perhaps I should have been explicit that the formula I gave

=INDEX(A1:A100,RandInt(1,100))

should be entered in 10 cells, as shown in the example on the referenced
site?


In article ,
"Bernd Plumhoff" wrote:

Your algorithm is still calculating nEnd - nStart + 1 random numbers and not
only the number of requested ones, I think.