Very few users are aware of the LARGE function, which lets you specify the position you want to extract.
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.
For more on the LARGE and SUMPRODUCT functions, visit the February 2013 issue of INTHEBLACK magazine.