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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...
help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to Compile Data from Different Sheets 2
VBA comparing sheets and cells 1
Auto Copy Data from one worksheet to another 1
Want code to copy to ABOVE row 22 column A on sheet 1 10
hide multiple worksheets based on a formula value in one cell 1
Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook 2
Find a value in a sheet and replace it with another value if it matches 8

Back
Top