| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can array formulas work if rows are inserted?
I have a worksheet containing 2 array formulas. If I insert rows within the
cell reference range the formulas appear to automatically update to reflect the new rows BUT the formula no longer returns a result just #NA. Is there a way to prevent this and allow row insertions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
| Unexpected (?) behaviour of OFFSET() in array formulas | Excel Discussion (Misc queries) | |||
| Insert rows | Excel Worksheet Functions | |||
| INSERT ROWS WITHOUT SCREWING-UP FORMULAS! | Excel Worksheet Functions | |||
Threaded Mode
