2nd Smallest
If you need to find the smallest value in a range, you would use MIN. Episode 1037 will show you how to find the second smallest value, third largest value and so on. Also in this episode, sort with a formula.
This blog is the video podcast companion to the book, a href="http://www.mrexcel.com/learnexcel2.shtml" Learn Excel 97-2007 from MrExcel /a . Download a new two minute video every workday to learn one of the 377 tips from the book!