Hello all:

I would like to know how to make this calculation. Below is a list of
products and types and prices. I would like to know how can I make that excel
should tell me all the permutations that's possible.

Product Type 1 Type 2 Type 3 Type 4 Type 5
Wood 1.29 1.39 1.49 1.59 1.69
Plastic 0.55 0.89 0.99 1.2 1.27
Metal 0.44 0.87 0.98 1.04 1.12

For example I want that in a certain cell it should start to tell me all the
variable prices possible if someone orders all three products. It should give
the results based whether the order is for type 1 for all of them, type 2 for
all of them and so on. It should then give the results for type 1 for wood
but type 2 for plastic and so on. I know there are a lot of possibilities.

Is there a way that I can see all possible variations and excel should give
the each result in a different cell?

Please help.

Thanks.

art wrote:
Hello all:

I would like to know how to make this calculation. Below is a list of
products and types and prices. I would like to know how can I make that excel
should tell me all the permutations that's possible.

Product Type 1 Type 2 Type 3 Type 4 Type 5
Wood 1.29 1.39 1.49 1.59 1.69
Plastic 0.55 0.89 0.99 1.2 1.27
Metal 0.44 0.87 0.98 1.04 1.12

For example I want that in a certain cell it should start to tell me all the
variable prices possible if someone orders all three products. It should give
the results based whether the order is for type 1 for all of them, type 2 for
all of them and so on. It should then give the results for type 1 for wood
but type 2 for plastic and so on. I know there are a lot of possibilities.

Is there a way that I can see all possible variations and excel should give
the each result in a different cell?

Please help.

Thanks.


Well, here's my interpretation. With your data above in A1:F4, put the
following in H2 and copy down to H126:

=$A$2&" ("&INDEX($B$1:$F$1,INT((ROW()-2)/25)+1)&
") - "&INDEX($B$2:$F$2,INT((ROW()-2)/25)+1)&
" "&$A$3&" ("&INDEX($B$1:$F$1,MOD(INT((ROW()-7)/5)+1,5)+1)&
") - "&INDEX($B$2:$F$2,MOD(INT((ROW()-7)/5)+1,5)+1)&
" "&$A$4&" ("&INDEX($B$1:$F$1,MOD(ROW()-2,5)+1)&
") - "&INDEX($B$2:$F$2,MOD(ROW()-2,5)+1)


If that's not what you are looking for, try showing an example of the results
you want.