title: Array of random numbers in Excel
body: <p>How can you create an array of random numbers using the <code>RAND</code> or <code>RANDBETWEEN</code> functions?</p>
  
  <p>I'm trying to simulate the average outcome of 10 rolls of a six sided die (for example) in one formula?</p>
  
  <hr>
  
  <p>I have tried the following in the past, but it only creates one random number and repeats it.</p>
  
  <pre><code>=SUMPRODUCT((ROW(A1:A10)^0)*(INT(RAND()*6)+1))/10
  </code></pre>