keep formulareferenses when adding columns or rows

V

vito

I wonder if it's possible to keep referenses in a formula when I'm adding a
column or a row?
Greatful for a answer
 
S

Stefi

Probably you should use absolute references like $A$1 instead of relative
ones like A1.
Stefi


„vito†ezt írta:
 
V

vito

This doesn't help because when you are adding a column the referenses change
in the formula whether its absolut or relative referenses.
 
S

Stefi

Then use INDIRECT(ADDRESS()) structure, e.g.
=INDIRECT(ADDRESS(1,4,4,1))
shall always refer to D1.
Stefi


„vito†ezt írta:
 
Top