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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.