View Single Post
  #4   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"

Hi MIke thank you !

I copied your formula then entert + cntr shift but it is not pasting the
array - is this the only way?

Thanks

"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