I have 6 columns of numbers and I want to generate a random number in each column, but I want to restrict each column to a set range of numbers. Think of it like a lottery with total numbers 1-39, but since only certain numbers are the most likely to come up (say in column 1 only numbers 1-10 and column 2 numbers 5-15 and column 3 numbers 11-19 and so on) I want only randomize that range and direquard the other numbers. Also, if possible, not duplicate from one column to the next.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
The RAND() function will return a number between 0 and 1, so in order to get a number in the range X to Y you would write the function like this:
=X+(RAND()*(Y-X+1))
Be aware, though, that they aren't really random numbers, just pseudo random.
=X+(RAND()*(Y-X+1))
Be aware, though, that they aren't really random numbers, just pseudo random.
Upvote
0
