RobJanine
asked on
SIMPLE EXCEL QUESTION RELATING TO DELETEING ROWS.
I am new to excel 2010, I am sure this didnt used to happen in excel 2003 but here is the problem:
I have a formula in say E10 that looks in cell E10 and E11. this works fine.
But if I delete row 11 the formula in E10 does not work anymore. seems to be putting #REF! in the formula in E10 where it references E11.
I want to be able to delete rows but other formulas referencing this row would still work. Row 12 would now be row 11 if 11 deleted.
Cheers
Rob
I have a formula in say E10 that looks in cell E10 and E11. this works fine.
But if I delete row 11 the formula in E10 does not work anymore. seems to be putting #REF! in the formula in E10 where it references E11.
I want to be able to delete rows but other formulas referencing this row would still work. Row 12 would now be row 11 if 11 deleted.
Cheers
Rob
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks alot Kevin, thanks for explaing the problem clearly too.
Cheers
Rob
Cheers
Rob
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
=(IF($B10=B11, (IF($E10=E11,"IN","OUT")),
if i delete row 11 this is what the formula now reads:
=(IF(B10=#REF!, (IF(E10=#REF!,"IN","OUT"))
Cheers