Array formula pros and cons

The advantages of using array formulas rather than single-cell formulas include the following:

■ They can sometimes use less memory.

■ They can make your work much more efficient.

■ They can eliminate the need for intermediate formulas.

■ They can enable you to do things that would be difficult or impossible otherwise. A few disadvantages of using array formulas are the following:

■ Using many complex array formulas can sometimes slow your spreadsheet recalculation time to a crawl.

■ They can make your worksheet more difficult for others to understand.

■ You must remember to enter an array formula with a special key sequence (by pressing Ctrl+Shift+Enter).



Was this article helpful?

0 -2

Post a comment