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

  • Thread starter Thread starter Arno
  • Start date Start date
A

Arno

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
 
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
 
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
 
Enter must be the last key held down.

Mike F
Arno said:
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
Click to expand...
 
Back
Top