Excel Forum



Excel Array Formula Series #4: Find Largest Improvement


See how to create array formula for finding the largest improvement in sales from one year to the next.

The formula MAX(D5:D9-C5:C9) will show you the biggest improvement
Remember to enter array formula with Ctrl + Shift + Enter

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.





Got a Question? Ask it Here in the Forum.