Deleting rows with formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chad - 25 May 2008 23:32 GMT

Hi All,

I have this excel sheet that has a bunch of formulas in it. My formulas
look at cells in the previous row. If I delete a row, the cells change to
#REF! This makes sense to me. Is there a way to write the formula so that
is just looks at the prior row instead of trying to find the row that is
deleted?

Thanks
Chad

Reply to this Message

JLGWhiz - 26 May 2008 00:43 GMT

Maybe if you used R1C1 style.

> Hi All,
>
[quoted text clipped - 6 lines]
> Thanks
> Chad

Reply to this Message

Dave Peterson - 26 May 2008 04:31 GMT

This formula in E5 will always point to E4:
=OFFSET(E5,-1,0)

No matter where the formula is located, this will always point to A1:
=INDIRECT("A1")

> Hi All,
>
[quoted text clipped - 6 lines]
> Thanks
> Chad

Signature

Dave Peterson

Reply to this Message