Thread: minimum from various columns without zeroes
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cutter
 
Posts: n/a
Default minimum from various columns without zeroes

How about:

=IF(MIN(F16,K16,P16,Z16)=0,SMALL((F16,K16,P16,Z16) ,2),MIN(F16,K16,P16,Z16))


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=488953

Reply With QuoteReply With Quote