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

Hi. I have a random list of names. Last name in one column, First name in another column. I need to start another sheet that will reference this random list and return an alphabetized list. Can you help me with excel rand?
Solved by M. Y. in 25 mins
On the Loan Valuation sheet, referring to columns titled "Beginning Balance, Interest Charge, Scheduled Payment, Ending Balance, and Total Cash Flow," I need all the cells in rows below where there is a number other than $0.00 in the columns titled "Random Default and Random Prepayment" to be $0.00.
Solved by B. F. in 22 mins
I have a random number in cell A1. I have another random number in cell B1. I want to check if the MOD(A1 / B1) = 0, and if so, keep the number in B1. If MOD(A1/B1) is not zero, I want B1 to recalculate another random number, and check again...
Solved by S. S. in 27 mins
I need help with this question: A casino manager wants to introduce a Xmas game (that gives the customers an advantage). The Game: 1. A random colour machine displays either GREEN or RED. 2. Customer picks a colour and wins if their colour is displayed 3. A round involves 10 games. Of which GREEN is displayed 6 times on average (to give the customer an advantage) 4. Pay out is the stake x 0.7 (so if you select green and bet $1, your total return is $1.70 if green appears. But you lose $1 if red appears) (the customer still has a small advantage) QUESTION: What is the optimal betting strategy, to ensure that the customer wins $50 after every round (10 games) if the customer started with $100. Please help me with this question.
Solved by K. S. in 25 mins
Hi, I need a formula that will allow me generate random letter between A-D (A,B,C,D). However, this random letter must not be the same as the letter in the cell before. For example, in A1 I had the letter "B", in A2 the random letter should be any of the following ("A","C","D")
Solved by V. Y. in 27 mins
A survey conducted by the Segal Company of New York found that in a sample of 189 large companies, 40 offered stock options to their board members as part of their non-cash compensation packages. For small- to mid-sized companies, 43 of the 180 surveyed indicated that they offer stock options as part of their noncash compensation packages to their board members. -Based on the scenario, set up a contingency table. -If a company is selected at random, what is the probability that the company offered stock options to their board members? -If a randomly selected company is a large company, what is the probability that it offered stock options to their board members?
Solved by D. Y. in 27 mins
I have a spreadhseet which relates to volume used. I have a start volume and an end volume with a daily maximum allowance figure which requires random spreading across a fixed period. It needs to be a figure under the daily allowed maximum but not the same figure daily.
Solved by Z. W. in 29 mins
Solved by E. U. in 12 mins
i need a formula to pick for exemple 10 random cells from a table with 30 column 1 to 30 and in down A to J the result i need it is something like this:5B, 27E, 2J.....etc
Solved by M. J. in 20 mins
i have created a spreadsheet with a date column (that contains a random date generator) and a time column (which again contains random times as to when an employee either entered work or left). I would like to create a pivot table (using formulas) in order to show - per day - the first time in and last time out. How do i go about it? Thank you!
Solved by F. W. in 30 mins