Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » LARGE and SMALL functions and their uses
LARGE and SMALL functions and their uses
Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?
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.
In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.
Added by Amanda on 26th November 2006
More Excel hints and tips, like:
 |
|
» Forum post: Pivot tables |
What are pivot tables used for?
