You could put all valid numbers in A1:A41 and use:
=INDEX(A1:A41,RANDBETWEEN(1,41))
Remember, RANDBETWEEN may return the same value more than
once. To produce 10 *unique* random numbers within your
given range is a little more complex.
HTH
Jason
Atlanta, GA
-----Original Message-----
I need to generate a list of 10 random numbers, between
3 and 78. These
represent identification numbers of stores. However,
some of those numbers
are not valid (i.e., 13, 15, 20-49,55-57). I
used "randbetween" to get the
numbers between 3 and 78. I've tried various
combinations of "IF" and "AND"
to screen out the numbers I don't want. Anybody have a
way to do this?
.
|