At a glance
While the MAX function allows you to extract the highest value in a range, the LARGE function lets you specify the position you want to extract.
The SUMPRODUCT function is Excel's most flexible function and can perform calculations that are usually only possible with array formulas.
Want to learn more about how these two functions work together? Download the sample Excel file and check out our video tutorial.
Neale Blackwood CPA runs A4 Accounting, providing Excel training, webinars and consulting services.