Highest Nth Number Number in a Range
You can extract the Nth highest (or largest) number from a range by using the Large() function.
For this example we have a range A1:B5 and we would like to extract the following:
In cell B7 - The first highest number in the Range A1:B5 In cell B8 - The second highest number in Range A1:B5 In cell B9 - The third highest number in Range A1:B5
The following picture demonstrates the use of the Large() function to solve this example.