Random Number Generator - Multiple, Non-repeating, results
I got it to work for the range 1-20, but am not sure what to change in the
formula to make the range 10-19. Sorry to be a bother and a dummy.
Thanks
A Long
"A Long" wrote:
It works! Not sure how, but it works! I'll study it to try to understand it.
Thank you very much
A Long
"Domenic" wrote:
The formula needs to be confirmed with CONTROL+SHIFT+ENTER, not just
ENTER. Excel will automatically place braces {...} around the formula,
indicating that you've entered it correctly.
Hope this helps!
In article ,
A Long wrote:
Domenic,
I don't know what I did wrong. I entered the formula in B2 and attempted to
copy it through B4, but I only got #NUM! in each cell. Any thoughts on what
I did wrong?
A Long
|