Random string from an array Excel
<p>I'm just wondering if anyone can solve a simple query in Excel. Basically I want a randomly generated string from an array.</p>

<p>The formula I have is this:</p>

<pre><code>=INDEX({"Day","Night","Mixed"},RANDBETWEEN(1,3))
</code></pre>

<p>This works, however, whenever I switch between worksheets the values change and are not fixed once randomly selected. </p>

<p>Anyone have any ideas?</p>