Does anyone have any suggestions on how to minimize the formul cell memory?
I get a table 10 columns x 5000 rows with given the same condition for each
cell.
Such as in cell AA1 = if($A1="","",B1*C1+D1), based on this given formula
copy it down from AA1 to AJ1, and then copy the cell from AA1-AJ1 to
AA5000-AJ5000.
It seems to take too much formula cell memory on this table,
does anyone have any suggestions on how to performance the same tasks with
less formula cell memory?
Thanks in advance for any suggestions
Eric