Thread: Restrict Randbetween formula to use as per my requirement

Hi All,

I am using the Randbetween formula for Ratings. Here i have selected the numbers from 1 to 4.

All i want to do is to restict the Randbetween formula to use "1 for 15 times", "2 for 20 times", "3 for 25 times" and "4 for 40 times" as per my requirement. Kindly let me know how can i do this?

I have attached the excel file for your reference.

Regards,
Harish S

Excel doesn't have anything built in to do this. See attached for one suggestion.

I have added a second sheet. This sheet has a column of 100 random numbers generated by RAND. The second column has 15 occurrences of A, 20 of B, etc. The column of random numbers is the named range RandNums. Both columns together are the named range RandomLookup.

I have added a column of data on the first worksheet highlighted in yellow, which will replace your existing column. Each cell uses the function LARGE to pick the kth largest number from the list of random numbers, and return its corresponding letter in the adjacent column.

There is another little table I added to confirm the distribution of these letters in the highlighted column.