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