Problem with MS Excel

  • Thread starter Thread starter aejaz
  • Start date Start date
A

aejaz

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

Some Additional Info :
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 on....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
 
One way to do this manually, with your sample data, insert a temporary column
and fill it with sequential numbers like:

Col A Col B
1 25000
2 27000
3 29000
4 31000

Then copy/paste column A and B like:
1 25000
2 27000
3 29000
4 31000
1 25000
2 27000
3 29000
4 31000

Then sort on column A and delete column A

HTH
Anders Silvén
 
{snip}
Some Additional Info :
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 on....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.
Click to expand...

I use (or at least used to use) Solver quite a bit and I have no idea
what you are trying to do.

I don't know what the duplication of data is supposed to accomplish,
how the duplicated data are 'linked,' the significance of the stages,
or -- most importantly -- the purpose of the exercise.

Sorry.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top