How to get randomly assigned groups into equal amounts?

[bwe89]

Hi everyone,

I am using =CHOOSE(RANDBETWEEN(1,2),"A","B") to randomly assign data into two groups A & B. But when I do for 120 contacts does not group them into two equal groups of 60, which is what I want. Instead, it will have one group with 68 and the other with 52.

Does anyone know a solution to make randomly assigning groups happen in equal quantities?

 

[Eric W]

You could just use RAND to assign a random number to each contact, then use SMALL and group everyone below the n/2 th value into one group, and everyone else into the other:

	A	B	C	D	E
1	Contact 1	0.123612	A	As	Bs
2	Contact 2	0.309422	A	10	10
3	Contact 3	0.334354	A
4	Contact 4	0.621878	A
5	Contact 5	0.877647	B
6	Contact 6	0.777637	B
7	Contact 7	0.733063	B
8	Contact 8	0.193756	A
9	Contact 9	0.942704	B
10	Contact 10	0.156775	A
11	Contact 11	0.772948	B
12	Contact 12	0.542172	A
13	Contact 13	0.134582	A
14	Contact 14	0.784151	B
15	Contact 15	0.865734	B
16	Contact 16	0.498663	A
17	Contact 17	0.912226	B
18	Contact 18	0.847757	B
19	Contact 19	0.699894	A
20	Contact 20	0.795236	B

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet6​

Worksheet Formulas Cell Formula B1 =RAND() C1 =IF(B1<=SMALL(B$1:B$20,10),"A","B") D2 =COUNTIF(C:C,"A") E2 =COUNTIF(C:C,"B") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>