Thanks Joe.
I tried it on a few samples and "like magic", the random numbers appeared
with just those employees I wanted to be in the mix. Really appreciate the
help.
Thanks again
Arthur

"JoeU2004" wrote:

"Arthur" wrote:
What if I have the lowest number as 1 and the highest
191 and there are 25 people eligible for testing

Put the 25 numbers in a range of cells, say A1:A25, then use the following
to select randomly:

=index(A1:A25,randbetween(1,25))


----- original message -----

"Arthur" wrote in message
...
Thank you for your reply. I understand what youre saying but it doesnt
solve the problem using keystrokes. What if I have the lowest number as 1
and
the highest 191 and there are 25 people eligible for testing€¦€¦that means I
would have to substitute 166 names€¦or allow the random between (1-191) to
run
and cross out 166 names. If I have 50 eligibles, then I would want to
randomly select 50 names only and not 191.
Thanks again
Arthur

"Bernd P" wrote:

Hello,

...
Example 1: select (49,80) and include 136 and/or 141 to that random
selection.

Select (49,82) and treat 81 as 136 and 82 as 141.

...
Example 2: select (49,80) and not use 59 and/or 72

Select (49,78) and treat 59 as 79 and 72 as 80.

You can do this with a helper cell - don't call RandBetween twice :-)

Regards,
Bernd