Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping rows synchronised
On Jan 4, 3:23*pm, "Tyro" wrote:
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- Hide quoted text - - Show quoted text - My apologies; In column A is a list of numbers. In column B is another list of numbers. In column C is the formula, say on row 10 A10 - B10. I need to be able to insert a cell in the middle of either list of numbers in A and B whilst keeping the formula in C saying A10 - B10 rather than say A10 - B11 if I added the cell say in B6. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping rows synchronised
Depending upon how you insert the cells, try
=INDEX(A:A,ROW(A10))-INDEX(B:B,ROW(A10)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ... On Jan 4, 3:23 pm, "Tyro" wrote: 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- Hide quoted text - - Show quoted text - My apologies; In column A is a list of numbers. In column B is another list of numbers. In column C is the formula, say on row 10 A10 - B10. I need to be able to insert a cell in the middle of either list of numbers in A and B whilst keeping the formula in C saying A10 - B10 rather than say A10 - B11 if I added the cell say in B6. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping rows synchronised
One way:
=OFFSET(C10,0,-2)-OFFSET(C10,0,-1) -- David Biddulph wrote in message ... On Jan 4, 3:23 pm, "Tyro" wrote: 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- Hide quoted text - - Show quoted text - My apologies; In column A is a list of numbers. In column B is another list of numbers. In column C is the formula, say on row 10 A10 - B10. I need to be able to insert a cell in the middle of either list of numbers in A and B whilst keeping the formula in C saying A10 - B10 rather than say A10 - B11 if I added the cell say in B6. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keeping the rows together | New Users to Excel | |||
Dependent Validation in SharePoint-synchronised list | Excel Discussion (Misc queries) | |||
Plotting on primary and secondary axes with 'synchronised' y values | Charts and Charting in Excel | |||
keeping rows intact during sort | Excel Discussion (Misc queries) | |||
Keeping duplicate rows | Excel Worksheet Functions |