MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Min and MAX

Posted by Jason Gottschalk on November 04, 2001 7:28 PM

How do I determine the 'next' min value?
In my range a1:g7, MIN(a1:g7) returns the correct value, but now I want to know the next minimum value.

If my values are 1 through 49, and Min(a1:g7) returns 1, how do I use MIN to return 2?


Posted by Aladin Akyurek on November 04, 2001 8:58 PM

=SMALL(A1:G7,2) gives the second smallest value.

=LARGE(A1:G7,2) gives the second largest value.