8 Random Numbers

[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

 

[Dave R.]

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.

 

[David J. Braden]

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