Get instant live expert help on I need help with excel random number between range

“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 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
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
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 help adding a random number to my excel burn down chart
Solved by B. U. in 22 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