Computers are great at randomization, and if I need to randomly select something, I use Excel to help. Excel has a very handy formula called RANDBETWEEN.
The way to use it: type
The smallest integer value that the function will return.
The largest integer value that the function will return.
NOTE: If bottom is a greater than top, the RANDBETWEEN function will return #NUM! error.
You can compare 2 cells using
e.g. =RANDBETWEEN(B2, B3)
Result: a random number between the number in B2 and the number in B3
Or by using actual numbers, like
Result: a random number (between 1 and 22)
Result: random number (between 100 and 200)
Result: #NUM! (because bottom is greater than top)
And yes, it will return the lowest number as well as the largest number in the range.