Random Number Generator Help

[Tkurtz]

Hi Guys,

What id like to do is in cell A1 generate a digit between 1 and 10. In cell A2 I would like to do the same. I would also like A2 to compare its digit to A1 and if its the same number, re-generate another. How can I do this? Thanks in advance.

[Ace_XL]

In A1 and A2
=RANDBETWEEN(1,10)

In A3
=IF(A2=A1,RANDBETWEEN(1,10),"")

[Tkurtz]

thank you for your response. I should have been more specific though. if A2 checks to see if the number it generated was the same as A1, i would like it to re-generate a number WITHIN A2 again. by writing over its number with a new one. not by incorporating another cell(A3). is this possible??

[BB1972]

Tkurtz, welcome to the forum.

Have a look at post # 4 in this thread: http://www.mrexcel.com/forum/excel-q...ng-values.html - it appears that this will do what you're describing.

Hope this helps.

[Tank997]

You can do it with the MRAND array function from the morefunc addin. Can't seem to find a link but If you search the net I'm sure you can find it

[Tkurtz]

thanks everybody for actually responding.

i have a similar yet different one now that i cannot figure out. in A1 I would like to again create a random digit 1-10 but this time in A2 i would like to create a random digit 4-20. There is an overlap so there is the possibility still of creating redundant numbers, which i don't want. Yet their array sizes are different. how would you go about doing that? excel just yells at me when i try different things. i figured it would be easier just to ask. Thanks guys.

[Tank997]

You will still getting duplicate number between 4 and 10 in A1 and A2, if I read you correctly. The =randbetween() formula only works in one cell. Without a helper cell, VBA or the MRAND formula, I mentioned, you will not be able to be 100% sure you will not get duplicate number.