mike_vr wrote on Tue, 9 Mar 2010 09:19:01 -0800:

Does anyone know how I can have six cells next to each other,
using the =RANDBETWEEN(1,49) function, where none of the cells
equal each other? I.e. a random lottery function without
having two of the same numbers. I'm trying to do this without
creating a huge nested If statement so any help would be
appreciated.

Technically, if you do not allow duplication you don't truly have random
numbers. However, there are sites that will produce both duplicated and
unduplicated "random" digits, for example,
http://stattrek.com/Tables/Random.aspx These could be put in a column
and selected sequentially.


--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not