Get instant live expert help on I need help with random number between 1 and 12
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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 have a list of: Name, Date Start, Date End, and Percent Allocated. One person may show up multiple times in the list with different start and end dates. My objective is to see if that person is ever allocated over 100%, and if so to flag that. For example, if John is allocated at 60% between 11/5 and 11/29 and 65% between 11/15 and 12/31, that should be flagged because between 11/15 and 11/29, he would be allocated at 125%. If Sally is allocated at 85% between 11/ and 12/31 and 10% between 12/1 and 1/31, that would not be flagged because she is only allocated at 95% between 12/1 and 12/31.
Solved by I. S. in 19 mins