Thread: MAX -1
View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

check out large() in help

"cheshire191" wrote:

ok .. i used the MAX function to return the largest number in a range of
cells. but what if i want to return the 2nd or 3rd largest number within the
range?

thanks in advance.