Ask Your Question

how to reference a cell relative to the current one even rows are bing inserted

asked 2018-10-20 20:32:36 +0100

drobble gravatar image

updated 2018-10-20 20:32:52 +0100

Hi Everyone,

I'm wondering how can I keep a reference (to another cell) up to date even if a row has been inserted between the rows (value / reference rows)

I defined the formula: =INDIRECT(ADDRESS(ROW()-2,COLUMN(),4))

e.g. in attached file: how can I keep the reference in cell B6 valid even if I insert a row between R4 and R6?

Thanks in advance drobble

C:\fakepath\cell references.ods

edit retag flag offensive close merge delete


Sorry why do you need indirect then?

m.a.riosv gravatar imagem.a.riosv ( 2018-10-21 00:00:48 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-10-20 22:52:35 +0100

Just put formula =B4 to your B6. See Addresses and References, Absolute and Relative in help.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-20 20:32:36 +0100

Seen: 81 times

Last updated: Oct 20 '18