| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can array formulas work if rows are inserted?
Most likely, inserting rows will not impact the array formula's ability to
function. Without your formula, though, it's difficult to say. However, is it possible that your formula returns #NA! if there are blank cells in the referenced range(s)? Test by clearing the cells in one of the referenced rows (not deleting it). Then Edit|Undo to put the values back. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Chris" wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
