Get instant live expert help on How do I pick a random number between 1 and 5

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a list of random generated numbers from 1 through 100. I need a formula that will list the number of instances for each number 1 through 100. For example: My list generates 1000 random generated numbers between 1 and 100. I want to know how many times the number 50 is resulted from the 1000 random generated numbers.
Solved by V. D. in 13 mins
GENERATE A LIST OF 20 UNIQUE RANDOM NUMBERS BETWEEN 1 AND 100.
Solved by D. H. in 29 mins
I want cell 1 to be true if number 1 is between range number 2-number 5
Solved by T. H. in 29 mins
I need to select all the #1 I have in my sheet after I have sorted then assigned random number to each between 1-3
Solved by F. F. in 17 mins
I need to generate two random numbers that cannot be equal. The number range is between 1 and 5. Currently I am using the Randbetween formula in two side by side cells. But I need advice on how to make sure they are never equal.
Solved by X. W. in 21 mins