RE: na
Closing this item.
Closing this item.
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.
Connect with us:
Call for assistance
We will call you back