Thread: How do a find a second Max?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kwiklearner
 
Posts: n/a
Default How do a find a second Max?

Hi, I'm trying to find the maximum and second maximum number out of a
range? I have tried: MAX(IF($A:$A<B1,$A:$A,0)). Any help would be
great.


--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909
View this thread: http://www.excelforum.com/showthread...hreadid=519936

Reply With QuoteReply With Quote