Thread: Array: Show only min values greater than "0"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arno Arno is offline
external usenet poster
  
Posts: 60
Default Array: Show only min values greater than "0"
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