How to randomly distribute rows from sheet 1 to sheet 2 & 3 with V
 

I need assistance. I need to take the data inputted in sheet 1 and evenly
distribute the data rows into sheet 2 (Experimental) and sheet 3
(Controlled). The purpose of this project is for case studies. Please help.

How to randomly distribute rows from sheet 1 to sheet 2 & 3 with V
 

Put in a dummy column

use a formula like

=if(rand()<.5,"Experimental","Controlled")
then drag fill down the column.

recalculate (F9) until satisfied with the distribution. use a formula like
=countif(D:D,"Experimental") to check

when you are satisfied with the distribution, Select the column and do
Edit=Copy, then Edit=PasteSpecial and select values

now you can sort on this column and copy your data.

--
Regards,
Tom Ogilvy


"luk_sr" wrote in message
...
I need assistance. I need to take the data inputted in sheet 1 and evenly
distribute the data rows into sheet 2 (Experimental) and sheet 3
(Controlled). The purpose of this project is for case studies. Please
help.