CODEWITHSUNDEEP
excel
Orweisman
Orweisman

Reputation: 171

Generate random numbers equaly in group

Is there any excel function to generate random numbers in groups and to ensure that the numbers will distribute equally?

For example, if i have 3 groups (a ,b ,c ) with list of 30 names in each one and i want to assign random numbers from 1-4 for each name in a group and to make sure that each number will be assign exactly (or close) number of times so ill get a distribution of 25% for each number

Thank you

Upvotes: 2

Views: 1111

Answers (1)

Greg Viers
Greg Viers

Reputation: 3523

You can do this with 3 columns. In the first column, generate some random numbers (I placed this in B2):

=RAND()

In the second column, rank the items from that first column:

=RANK(B1,$B$1:$B$16)

Lastly, if you use QUOTIENT, it will break them into 4 equal groups:

=QUOTIENT(C1,4)+1

Upvotes: 2

Related Questions