[hard to explain problem in few words]

Hi,
I want to generate many many results from excel.
I've got 5
columns
A B C D E

equation for A is A = B*C*D*E

now I've got many inputs for columns B to E. What I want to do is take the first input of B multiply by the first of C, then multiply by the first of D, multiply by the first of E. That'll be one result for A. The next result would be first B, 2nd C, first D, first E. So basically getting all the combonations of each of B C D E times together.
Columns B C D E are not the same size.

IS there a way to solve for A quickly?

Thank you

Yeah i think you mean this:

=SUM($B$1*C1*$D41*$E$1)

using absolute references for cells B, D and E will use the same values only cell C will change when you copy the formula down.

I have attached a file for you too see what i have done.

all you need to do is make the values you need to remain as constant a absolute reference by pressing F4.

I hope that helps

Actually this is a bit clearer,

it's probably best to use 4 columns for each value that you eed to change

just look at the table and youe see what i mean buddy.

thanks. so what happens if columns are differet lengths,


your help has been great

I dont understand what you mean by:

Colums different length

Bearing in mind the number of combinations are potentially huge, is all you want the diferent combination sof B C D E and what they are multiplied together?

If so the following macro may work

Does that help

Regards

Dav