Deleting rows with formulas

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

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
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mid column sum formulas with varied ranges to sum 17
Delete rows takes forever 4
Insert Row also adds formulas and moves cursor 2
Excel Help to copy information from one row at a time to another sheet 1
Column number of last column that returns value ignore formulas 8
Macro to delete entire row 4
Keeping formulas on an insert 1
Deleting a row as a condition of a formula. 2

Back
Top