I have need of a rule, but have not been able to formulate correctly. I"ve abstracted the cubes, elements and dimensions to make it easier to describe.

cube1,

dimensions A,B,C,D

cube 2

dimensions A,E,C,D

elements within dimensions described by number, ie A1, A2 etc. C, in particular, has about 100 elements (months)

I want a rule cube 1 (B1, Cn, D1) = cube 2 (E1, Cn-1, D1) for all elements in A

How do I create a reference for Cn-1 for ALL n? (almost seems like a loop is needed)

Thanks for any who take the time to help!

cube1,

dimensions A,B,C,D

cube 2

dimensions A,E,C,D

elements within dimensions described by number, ie A1, A2 etc. C, in particular, has about 100 elements (months)

I want a rule cube 1 (B1, Cn, D1) = cube 2 (E1, Cn-1, D1) for all elements in A

How do I create a reference for Cn-1 for ALL n? (almost seems like a loop is needed)

Thanks for any who take the time to help!

The post was edited 1 time, last by PaulStafford ().