Frequently asked questions
How can I randomize 50 subjects into 2 treatment groups with exactly 25 subjects each?
Proceed as follows:
Use the Fill column command (Tools menu) to do the following:
Fill column A, rows 1 to 25 with value 1, and rows 26 to 50 with value 2.
Fill column B, rows 1 to 50 with a random number, using the formula RAND(1) (be sure to select the option "Convert formulas to values").
Next, sort the data according to column B (Tools menu - Sort rows).
You now have a random number 1 or 2 (25 of each) in column A.