Thread: Array: Show only min values greater than "0"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Array: Show only min values greater than "0"
Hi,

=MIN(IF(ISNUMBER(P3:P10)*P3:P100,P3:P10,""))

Array entered

Mike

"Arno" wrote:

Hello,

From the array below I need: show minimum values BUT greater then "0" (I
must exclude zero)

=MIN(IF(ISNUMBER(P3:P10),P3:P10,""))

Hope you can help -Thank you !

Arno
Reply With QuoteReply With Quote