8 Random Numbers

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

Hi,
Can I use RANDBETWEEN(bottom,top) to generate 8 random
integers between an upper and lower bound without picking
the same number twice?
Thanks,
Jerry
 
Randbetween doesn't have anything that allows it to loop around within
itself to see that it's not giving you the same # twice.

There is more than one message on this group, in the past, that deals with
creating random numbers that don't overlap, with VBA. I would suggest a
google search of the archive.
 
In addition to what Dave R wrote, which IMHO is a very sound suggestion,
given the tons queries and answers on this, I suggest you look into
PopTools, a free add-in (Google it) with a wonderful pseudo-random
number generator. If you use it, as some of my clients end up doing,
consider supporting the guy somehow for his superb efforts and results.

Dave Braden
MVP - Excel
 
Back
Top