View Single Post
  #1   Report Post  
pilzner
 
Posts: n/a
Default How do I get MAX, MAX -1, MAX -2


I have a list of numbers that I need the MAX number for......so far
that's easy, but I also need MAX -1 and MAX -2.

In other words I need the 3 greatest numbers in the list.

I DO NOT want to sort.

I need this as a formula.

Thanks in advance for your help

-P


--
pilzner
------------------------------------------------------------------------
pilzner's Profile: http://www.excelforum.com/member.php...o&userid=25976
View this thread: http://www.excelforum.com/showthread...hreadid=393410