Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey Group
I am wondering if you can help me with this problem..i am developing a linear program in Excel.. Heres my problem I have over 4000 pieces of data ...now the way i use this data requires me to duplicate every data point..allow me to explain I have 12 stages. Lets say for the first stage..my data is STAGE 1 25000 27000 29000 31000 Now in the second stage , i have to duplicate each value twice..so my second stage looks like this. STAGE 2 25000 25000 27000 27000 29000 29000 31000 31000 For shorter stages, i manually copy pasted the values..thats fine.. For larger sets of data,I have tried using the drag feature, but its doesnt work . Doing it manually is time consuming because i have stages where i have to duplicate 2048 pieces of data..that would mean 4096 data points Each of the "duplicated" values are "linked", for example,25000 in stage 1 is linked to the TWO "25000"'s in stage 2..and so....If anyone in the group uses SOLVER to solve Linear Progams in Excel, you will have an idea about what i am trying to say. Could anyone provide any solutions? Thanks Aejaz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Microsoft Excel has encountered a problem | Excel Discussion (Misc queries) | |||
Microsoft Excel has encountered a problem | New Users to Excel | |||
Microsoft Excel has encountered a problem... | Excel Discussion (Misc queries) | |||
Microsoft Excel Opening Problem | Excel Discussion (Misc queries) | |||
Microsoft Excel Problem | Excel Discussion (Misc queries) |