Excel+How+to+Return+the+2nd+Largest+or+Smallest+Value+in+a+Series+If

Excel How to Return the 2nd Largest or

Smallest Value in a Series

If you wish to display the 2nd highest profit grossing month of the year or the 2nd worst you need the following

The =max and =min Excel 2003 functions return the largest, or smallest value of a series.

What if you need the 3rd just substitute the value of “n” to that which you require?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

For example, if you have a spreadsheet with the following values:

A1: 11

A2: 92

A3: 45

A4: 28

A5: 37

To return the 2nd largest value of the series, which would be 45:

=large(a1:a5,2)

To return the 2nd smallest value of the series, which would be 28:

=small(a1:a5,2)

Hope this assists.