Use the Large and Small functions is Excel to find the Nth largest number in a list.

For example:

=Large(A2:E2,3) will return the 3rd largest value in the data set.
=Small(A2:E2, 2) will return the 2nd smallest value in the data set.

Joseph Harris
Excel Help

No related posts.

This entry was posted on Monday, March 23rd, 2009 at 10:31 am and is filed under Excel Quick Tricks, Functions. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.