Hello,

instead of using
=randbetween(LOW,HIGH)
you could use
=uniqrandint(HIGH-LOW+1,FALSE)+LOW-1
entered normally (no array-formula).
See www.sulprobil.com for my UDF uniqrandint().

The second parameter (FALSE) tells my function to be non-volatile, that
means: do not recalculate with each F9.

HTH,
Bernd