Keeping rows synchronised
You need to explain your question better. You cannot insert rows in columns
A or B. When a row is inserted, it is inserted in every column. Are you
talking about insterting cells in columns A or B? Perhaps you could provide
an example of what you're doing.
wrote in message
...
I have 2 columns of numbers - in A and B and then in column C the
formula A-B.
When I insert rows in either column A or B it then changes the formula
in C to deduct the row either above or below the relevant cell.
Could someone help me with the (INDEX i think) formula I can put in C
which is not effected by the insertion of rows in A or B.
Thanks
Gavin
|