# Get instant live Excel expert help with RAND Function

“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

GENERATE A LIST OF 20 UNIQUE RANDOM NUMBERS BETWEEN 1 AND 100.
Solved by D. H. in 29 mins
Hi. I am working with Microsoft Excel. I have a list of random integers from 0-2 and in a different cell i want to select all the 0's in a cell, all the 1's in a different cell and all the 2's in a different one. How would i do that?
Solved by I. Q. in 19 mins
I would like to create a line chart where in if the data was random number within 1-10.
Solved by B. J. in 16 mins
I would like to create a line graph using the random numbers from 1-10 in 10 cells.
Solved by V. E. in 16 mins
I would like to create a randomizer number from 1-8 for 20 cells. I will be using it on random auditing.
Solved by T. A. in 26 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
Problem 3: The sheet called "Season Sim" uses the Log5 probabilities to simulate every matchup (in proper order) for the Rockies 2017 regular season. The promary statistics we keep track of are the longest streak (in W2), the total wins (in U166) and the Streak/Win Ratio (in Z2). On the formulas tab, each time you click "Calculate Sheet" (or Calculate Now, slightly slower) it will "rerun" the 2017 season for the Rockies. New random numbers generate a new sequence of (hypothetical) wins and losses. Click the "Calculate Sheet" button for a little while and tell me the longest and shortest streak you manage to produce.
Solved by I. A. in 14 mins
I need 180 tabs that can be randomly selected one time, in one spreadsheet. Once a tab is selected, it cannot be displayed again until all tabs have been randomly selected. I can then repeat the 180 sequence again with all tabs available. I do this 4 times per game. Each time represents a quarter for a basketball game. I need the random selection because only one reading can be used per card. My advanced age and arthritis makes it difficult to shuffle the deck of 180 cards once I have gone through the entire deck.
Solved by Z. Y. in 27 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
Hi, I need to get multiple random results without returning the same result. I've tried 'IF' but can't seem to get it right. Thank you
Solved by D. D. in 15 mins