Hello
I use the random between function to randomly select employees for testing.
I've outlined the problem I'm having below.

Each employee is required to be randomly tested and has a unique number
assigned to them (1-191).

The formula =randbetween(1-191) works well for my purposes when all of the
ones being tested fall between those parameters, but there are many instances
when I want to add specific numbers to the random selection process.....or
not use some of them in that group.

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

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

I'm sure there's a simple way of adjusting the formula as needed, but I
haven't been able to figure it out. Can you help?

Thanks
Arthur