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 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
Problem 2: Suppose we are simulating a matchup between CO and NYY. We generate a random number between 0 and 1 and compare it to the win probability. If we randomly generate 0.45, is our conclusion that CO won or lost?
Solved by F. A. in 18 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.