|
Featured Tutorial
Featured Macro
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.
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.