Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Return the 2nd Largest or Smallest Value in a Series

Summary: Inside a Microsoft Excel 2003 spreadsheet, need to display the 2nd-highest profit-grossing month of a year, or the 2nd-worst?

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)

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Functions and Formulas page.

Print this tip.

- Subscribe!

Search the Site: