Randbetween to take numbers based on the cell values

I don't really understand what you want. Here's my guess:

A1:A100 = range of employee numbers
B1:B100 = corresponding rating for each employee number, A - D

E2:H2 = {"A", "B", "C", "D"}

E3 = COUNTIF($B$1:$B$100, "="&E2)
then pulled across for F3:H3

E4 = RANDBETWEEN(1, MATCH(E3, {15, 20, 25, 40}, 1) )
then pulled across for F4:H4

Of course, I have no idea whether you want that array to be a floor or a ceiling (this treats it as a floor) or what.

Hi there,

It's interesting how many interpretations can be put on a query

On reading your query,my initial reaction was that you wanted a random number between 1 and 4 generated 15 times, a random number between 2 and 4 generated 20 times, a random number between 3 and 4 generated 25 times - not sure why you'd want a random number between 4 and 4 generated 40 times, but who knows????

Anyway, going with my initial reaction, enter the following formula into Cell B2 and copy it downwards:

=CHOOSE(RANDBETWEEN(IF(ROW() <= 16,  1,  IF(ROW() <= 36,  2,  IF(ROW() < 62,  3,  4))),    4),      "A",  "B",  "C",  "D")

Please let me know how much I've misinterpreted your query!

Regards,

Greg M

Thanks for sharing the link, I got the answer from link provided.