Howdy;

This is rather difficult to describe, but here is a stab.

I have a table of random numbers (20 col x 25000 row). On another tab I
have a similar table and want to look at the random number one column at a
time. If the random number is < some value, perform a rather lengthy
expression. If it is = to the value, do nothing. Once a cell in the target
table has been calulated once from the above routine, it will have to be
calculated for the remainder of the columns. In addition, it will also
affect the cells above and below it. The random number associated with their
location will be compared to another value and then have one of two
expressions performed. Picture a "<" shape, or wedge, going across columns
and increasing the number of rows rows. Once a tip is created, the wedge
grows up/down as more neighbors are affected.

I have this working now through a mega-equation which is slow and evaluates
everything (2-two dimensional lookups plus the true/false equations). I
would like to speed things up and only perform calculations on cells that
need it, veruses every cell.

Any thoughts, suggestions, questions?

Regards,
Tim