» Returning the Nth Largest / Smallest Values in a Range

CATEGORY - Excel Formula and Function VERSION - All Microsoft Excel Versions

Problem:

Finding variously ranked numbers in List1. For example, the second largest number, the third smallest number, and so on.

Solution:

Use the LARGE and SMALL functions in the following formulas:
To find 2nd largest number enter:
=LARGE(A2:A8,2)
To find 3rd smallest number enter:
=SMALL(A2:A8,3)