| How to keep cell number in formula inserting a new row ? | jrccc | 6/27/12 1:45 AM | Hi, Here is my issue. I have my spreadsheetA1 A2 A3 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 |
| Re: How to keep cell number in formula inserting a new row ? | anandvarma | 6/27/12 4:43 AM | Dear Jrccc, have a look at the address function anand varma |
| Re: How to keep cell number in formula inserting a new row ? | MarinusP | 6/27/12 3:13 PM | Hi You can use an ArrayFormula if I understand the situation right. If you would like to do so, then I suggest that you share an example spreadsheet with anyone with the link, to edit. Another way might be, to use the function INDIRECT, or INDEX whic |
| Re: How to keep cell number in formula inserting a new row ? | jrccc | 6/28/12 1:17 AM | Thanks a lot Marinus and Anandvarma !INDEX was exactly what I was looking for ! Finally I implemented that way and it works : In my formula, I replaces the cell A2 by INDEX(A1:A3;2;1)Formula INDEX(A1:A3;2;1) returns the content value of A2. Here 2 i |
| Re: How to keep cell number in formula inserting a new row ? | MarinusP | 6/28/12 12:27 PM | You're welcome! |