Learn Excel 365 formulas fast! From AutoSum to Intellisense, learn how to work smarter and analyze data with ease. Tips, ...

Once deleted, add the array formula again in the first cell and then copy it down to the required cells. Read: Excel ran out of resources while attempting to calculate formulas.

Microsoft has been adding new features to Excel lately, and the latest one could change the way people work with formulas.

The Problem: Dynamic Array Formulas Don't Work in Excel Tables A dynamic array formula is a formula whose result spills over from one cell to other cells.