Excel Forum
Similar Content
Sum Values from Every X Number of Rows in Excel
Tutorial: Add values from every x number of rows in Excel. For instance, add together every other va...
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Formula to Get Value of Last Non-Empty Cell in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel....



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.