A
Arthur
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
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