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?