“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

GENERATE A LIST OF 20 UNIQUE RANDOM NUMBERS BETWEEN 1 AND 100.

Solved by D. H. in 29 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 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

I am trying to generate random values between 0 to 1 with two decimal places in 31 rows such that my sum is a certain value. Need help to generate them.

Solved by O. C. in 18 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