View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] deniseandgavin@gmail.com is offline
external usenet poster
 
Posts: 13
Default Keeping rows synchronised

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