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...
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...

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.