| 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 |
| 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 | |||
Threaded Mode
