True Absolute Reference

[f252863]

Hi,

When I insert columns I have to redo all my formulas. I understand
you can use indirect but I don't think it will work.

My formula is a simple =$E$20-$G$20, when I insert two columns it
becomes =$G$20-$I$20. How do I force it to keep the original cell
addresses?

Many thanks!

 

[T. Valko]

INDIRECT will work:

=INDIRECT("E20")-INDIRECT("G20")

 

[f252863]

THANK YOU!!!! Just cut down processing changes from 20 minutes to 2,
now I'm working on getting it down to 20 seconds.

 

[T. Valko]

You're welcome!