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 use a formula that chooses random number of desired names from a list of names. Can you help me with randbetween excel?
Solved by E. U. in 17 mins
Hi, I am trying to create an if,and ,or function for a spread sheet. I need to be able to put y into the sheet in random order. I have added an excel sheet which has example of the if formula which i am trying to create. I would like to know if this is possible. do i need to use if, and ,or functions. I think the spread sheet explains what I am trying to do. I have highlighted in yellow what I have started with. for the formula. i just don't know how to put it together to make it work.
Solved by K. Q. in 26 mins
I have 3 Column .... when i fill the first 2 column after that i'm fill excel randbetween formula in the 3rd column ............. but i want when my typing cursor is on the 3 column i'm just click on the TAB or ENTER button and after clicking the one of them my RANDBETWEEN formula run and give me random number the formula is [ =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1000,9900) ] ......
Solved by D. J. in 30 mins
I am trying to use excel to come up with a flow plan for my students. I have 5 color stations (yellow, pink, purple, green, and blue). I don't want them following each other. i.e. The ones that start on blue, will be sent to random color stations. Some yellow. Some pink. etc. In the end, they will need to have done all 5 stations. So, one students might go blue, yellow, pink, purple, green. Another might be blue, purple, green, pink, yellow. Another yellow, green, purple, pink, blue. Do you know any rand function that will help me determine the various routes?
Solved by I. J. in 18 mins
I have a list of codes in column A and their text counterpart in column B. Column C is random list of column A. I would like to create Column D to be: IF column C=A then D=B
Solved by V. F. in 30 mins
hello there! 1)please open up Userform in the file and select date from combobox that is linked to column A in sheet name "Purchasing"you will see that it shows a random value like 45632 instead of date format as shown in column A 2)same for column I which shows currency value it excludes the dollar symbol and put only digits please can you fix it?
Solved by V. B. in 18 mins
rotating a list of numbers random but keeps order they were rotated in
Solved by V. Q. in 22 mins
I have 3 columns going down from A1 to a1000 same for b and c in each row there are three random numbers example A1 has 1 b1 has 2 c1 has 3 next row another three random numbers ,I would like to be able to identify the most popular three numbers across the three columns out of the 1000 three number sequence I have across the three columns numbers go from 1 to 6
Solved by A. E. in 24 mins
The file Homework#7.xlsx contains 50,000 random numbers in column A. Write a sub that creates an array called frequency of size 10 (frequencies for short). The sub should populate the array by looping over the random numbers and putting them into "bins". Specifically, frequency(1) should contain the count of all the random numbers from 0 to 0.1, frequency(2) should contain the count of all all random numbers from 0.1 to 0.2, and so on. Because every random number has to be in one of these "bins", the counts should sum to 50,000, which you should check. Report the final contents of the array and the sum of the counts in a Msgbox.
Solved by M. L. in 28 mins
hello I need help with random values and formulas on my excel sheet. can you please help me with these?
Solved by M. L. in 16 mins