How to multiply each cell with another in an array

Not sure which data present in which cell can you please attach a sample workbook with expected outcome?

Thanks for the file but I am unable to understand the logic It will be helpful if you add those values nearby the output cell for better understanding.

It looks to me like you want to create a column that computes the product of each combination/permutation. So, in many ways, this looks to me like a combination/permutation type problem (which I never do, so I'm not very good at programming them). My approach might look something like this (comma delimited):

Please Login or Register  to view this content.

The part that is left to figure out is what formulas to put in columns F, G, and H that will generate the permutations. In your example, you appeared to generate the permutations in lexicographic order, so if we can come up with a set of cell formulas that will recreate that logic, we should be able to do this. Maybe something like:

Please Login or Register  to view this content.

though this might be tedious to extend to larger matrices.

In the spirit of brainstorming, would there possibly be a matrix function/multiplication that could represent this problem? If one could see a matrix representation of the problem, then we could possibly use one of the built in matrix functions (like MMULT()) to get at this.

Cheers, thats an approach I never really thought about using. I did think about using matrices but the problem I had was that I couldnt think/remember how to create a function which represented what I was doing. Its been a long time since I did anything with matrices. You're right about me using a lexicographic order when I did it, but any order would be ok, its just what came to mind first.

Ive come up with one way of doing it which involves loops, and once again because my knowledge of programming is rather basic ive done it from a first principle approach which is probably very inelegant, and ive used a goto to create the loop which I think is probably a no-no. Anyway this is what I came up with:

Please Login or Register  to view this content.

and ive used a goto to create the loop which I think is probably a no-no.

I don't know that it is a no-no, but I think a lot of programmers would use it as a method of last resort. I think I would have used For...Next loops (http://msdn.microsoft.com/en-us/libr...=VS.71%29.aspx) for creating the permutations (pseudocode):

Please Login or Register  to view this content.