You may consider to download and install the very assistance add-in: MOREFUNC
http://download.cnet.com/Morefunc/30...-10423159.html
Now, you should select 6 cells and while selected to put the cursor into the
formula bar and type: {=MRAND(,1,49)}
*** This is an array formula, and is to be confirmed with CTRL+SHIFT+ENTER
rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
Excel, when the formula is entered as an Array formula.
Micky
"mike_vr" wrote:
Hi there
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.
Cheers
Mike