» Returning the Nth Largest / Smallest Values in a Range
Finding variously ranked numbers in List1. For example, the second largest number, the third smallest number, and so on.
Use the LARGE and SMALL functions in the following formulas:
To find 2nd largest number enter:
To find 3rd smallest number enter: