| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| Sheet Names Randomly Change (Chart Sheets Only) | Excel Discussion (Misc queries) | |||
| move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
| how do i create a spread sheet with randomly placed numbers 1-500. | Excel Discussion (Misc queries) | |||
| How do I save an OLAP connection to distribute with an Excel sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
