| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
True Absolute Reference
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
True Absolute Reference
INDIRECT will work:
=INDIRECT("E20")-INDIRECT("G20") -- Biff Microsoft Excel MVP wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
True Absolute Reference
THANK YOU!!!! Just cut down processing changes from 20 minutes to 2,
now I'm working on getting it down to 20 seconds. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
True Absolute Reference
You're welcome!
-- Biff Microsoft Excel MVP wrote in message ... THANK YOU!!!! Just cut down processing changes from 20 minutes to 2, now I'm working on getting it down to 20 seconds. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| absolute reference | Excel Discussion (Misc queries) | |||
| Absolute Reference | Excel Discussion (Misc queries) | |||
| absolute reference | Excel Discussion (Misc queries) | |||
| absolute reference | Excel Discussion (Misc queries) | |||
| absolute reference | Excel Worksheet Functions | |||
Hybrid Mode
