Get instant live expert help on I need help with random number generator between 1 and 100
“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 items in column A, this list can be any length whatsoever, at any time, added to or taken away from. I also have a random number generator that generates an integer between 1 and the total number of items on column A. what I then want to do is use the random number I've generated to call whatever corresponding item on the list and show it to me somewhere near the default page location. For example if I call item 315, I want whatever is in A315 to appear somewhere near the top of the page, instead of having to scroll down to A315 myself.
Solved by V. A. in 16 mins