Google Product Forums
How to keep cell number in formula inserting a new row ?
Jun 27, 2012 1:45 AM
Posted in group:
Sheets : Ask a "how-to" question : Desktop (specify browser/OS) :
Here is my issue.
I have my spreadsheet
I have a formula (in another tab) which compares a value "X" with the content of A2.
When I insert a new row between A1 and A2, A2 becomes A3, and then my formula compares the value with the content of A3. But I still want to compare my value with the content of A2.
Is there a way to keep always the same cell number in my formula, in despite of insertions ?
I took a look to ArrayFormula, but I don't see how it could work with that feature.
Does someone know how to solve this issue ?
Thanks a lot,