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

I need to generate random values between two values. Every time I input this value, it generates to 1.000 =RANDBETWEEN(0.450,0.460)
Solved by I. J. in 18 mins
Looking for a way to get a MIN result across a row of numbers but after a randomly chosen spot. Ex. Row 1 ( Commas are separate cells ) 455,2,223,5667,32323,56,3,2323,34 I have used the MAX function to locate the MAX value in Row 1 EX - 32323 I need to Return a MIN result after that MAX number position. EX - 3 The MAX will be in random spots every time I input data into a new sheet.
Solved by M. U. in 30 mins
I have entries in some fields that are a combination of numbers and dashes. Even though that field is set to 'text' format in excel, when saving it as CSV, it converts the entries to dates or random numbers.
Solved by A. L. in 17 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.
Solved by X. W. in 21 mins
I have created a macro that generates random numbers into a single cell by me holding down CTRL+M. I am trying to sum the cumulative running balance of all of the numbers that it generates. For example of the cell I have chosen as the random number generate, generates 1, 5, 7, 2, 8 in five draws, I am trying to calculate in a different cell, the running total, which in this example would be 23.
Solved by X. F. in 23 mins
I am helping create a chart for peer evaluation. Each person needs to evaluate three other peers from random. Two of those have to be from Group A and one from Group B. There should be only 3 occurrences of evaluation of each individual (or around that many).
Solved by K. L. in 18 mins
I have a random cell layered over one my cells. When I click inside the empty cell I can type into the cell but it does not display anywhere other than inside this box. The entire home box is grayed out. How do I get rid of this cell?
Solved by I. C. in 21 mins
i need help adding a random number to my excel burn down chart
Solved by B. U. in 22 mins
I need a formula that looks up a value in a set of random data and that returns the value 1 column to the left (-1) and one row down (+1) from the looked up value. Basically I do not want to specify which column or row, other then the fact that I want to specify that I want to look up a value (1A) in an array (A1:S28) and return the relative coordinates. So theoretically If I look up the value 1A, which is located in C3 in the array, I want to return the value in cell B4. However It could also be located in R24, which would make my desired outcome the value contained in cell Q25.
Solved by G. W. in 19 mins
I have a list of items. Each item row includes columns for Name, Category, and URL. I want to generate a random sample of that list, ensuring that 1) only one item from each category is listed, while 2) every unique category value is represented in the sample.
Solved by Z. D. in 22 mins