Replying to self....
Creating named ranges for {z,y,x}, {w,v,u}, etc. and then also
{a,d,g}, {b,e,h}, etc., allows these named ranges to be used in the
equations for A1:C3. It's all very readable. The only downside is that
the values returned are only the values in that row or column so
getting the next higher or lower value is a bit more effort, but it
works.
Cheers all,
Mark
On Thu, Jul 31, 2008 at 2:02 PM, Mark Knecht <[EMAIL PROTECTED]> wrote:
> 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]
