The =max and =min Excel 2003 functions return the largest or smallest value of a series. What if you need the 2nd largest or smallest values? Or the 3rd?

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)**

*Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Return the 2nd Largest or Smallest Value in a Series.*

Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.