Hi,
Thanks to those who responded earlier today to my questions. I
appreciate it. Hopefully this new one will be solvable also. Thanks in
advance.
OK, so I now have my big array built with something on the order of
10K cells. (100 row x 100 columns) Now I'm trying to figure out how to
code the equations inside the array such that they can be copied and
pasted to make the array larger.
The basic array looks like this:
z y x
w v u
t s r
$500 $510 $520
a b c $500 [a1] [b1] [c1]
d e f $510 [a2] [b2] [c2]
g h i $520 [a3] [b3] [c3]
I'm sure this format won't survive emailing exactly intact but
basically I'm showing a 3x3 array where the prices identify the
columns and rows. Now I need to write equations inside this array that
for the row use the row parameters a-i and for the column use the
column parameters r-z. An equation in any given cell might be the
equivalent of
[a1] = a-z
[b1] = a-y
[c1] = a-x
and then for the second row
[a2] = d-z
[b2] = d-y
[c2] = c-x
Basically, I need to equation to always access the data on its row
or column as I copy and paste it. Is there a way to do this?
I was thinking about maybe making the group {a, d, g} an array, {b,
e, h} another array, and so on, and then writing the equation using
the name of the array with an offset based on the row. I don't know
exactly how to do that but I suspect it's do-able.
Any comments and/or other ideas warmly welcomed.
Thanks,
Mark
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
