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

2. Now use the RANDBETWEEN function in Microsoft Excel to select three simple random samples of 10, 50 and 500 days from the population
Solved by G. H. in 17 mins
I need to take a string (without any spaces) and find parts of this string in other strings (without any spaces) in my workbook. The strings are just random letters and not full words, they have no spaces and I'm not sure exactly what I want to search for. I just want to find the matching sections of my different strings of data
Solved by V. U. in 12 mins
I have a master sheet that uses indirect to reference another sheet, and I want those two random cells to add together.
Solved by E. E. in 27 mins
Excel keeps changing my 10 digit number that I enter and adds a decimal points followed by random numbers.
Solved by S. Q. in 17 mins
Hello, I'm conducting a statistical sample on a worksheet and from the 3000+ data points, I need to pull all of a row's contents for 51 of 3000+ identified from a random number generator (separate worksheet) my workplace uses. How do I take those 51 data points and highlight all of its rows contents (only those 51)?
Solved by O. Y. in 24 mins
I have large data base which needs to be sorted out. 1st Column is fixed with each cell having equal interval 10, 20, 30... And 2nd Column is having variable with colours Yellow and Red at random interval. Sorting is required only for any one colour (For example Yellow, then in Coloumn (C3) & (C4) it should return 20(in C3) -40 (in C4), 80(in C3) -130 (in C4).
Solved by I. C. in 21 mins
Now use the RANDBETWEEN function in Microsoft Excel to select two simple random samples of 10 days sample and 500 days sample from the population. Using just your samples, calculate the mean, median, standard deviations and mode if applicable for each random sample. [20%].
Solved by D. S. in 26 mins
Example data sets: ABC5789A ABC5D789A Where "789" are a random string of three numbers that I need for my VLOOKUP formula. ABC5 is the only constant, but the data is written as one of these two ways.
Solved by F. F. in 22 mins
I need a help with formula. In my staff sheet formula assigning free(not logged) terminals (from pick terminals sheet) to every staff with "pick task next to them. The problem is if I add (to the person in the middle of my list) "pick" task all terminal numbers under that person will change.They need to stay the same until "pick" task will be removed from them. And also them terminal number should be add random not one after another if it's possible
Solved by I. A. in 11 mins
i have multiple names in excel. how do i shuffle so the same name is not repeated multiple times and then pick a random name for a raffle draw
Solved by K. L. in 27 mins