Array: Show only min values > greater than "0"

[Arno]

Hello,

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

=MIN(IF(ISNUMBER(P310),P310,""))

Hope you can help -Thank you !

Arno

 

[Mike H]

Hi,

=MIN(IF(ISNUMBER(P310)*P310>0,P310,""))

Array entered

Mike

 

[Mike H]

Hi,

The check for isnumber isn't necessary

=MIN(IF(P310>0,P310))

Mike

 

[Arno]

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

 

[Mike H]

Paste the formula in your cell then follow these intructions

'This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike

 

[Mike Fogleman]

Enter must be the last key held down.

Mike F

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]

Thank you it worked now! Wisha good day ! Ciao Arno