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

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

Array: Show only min values greater than "0"
 

Hi,

The check for isnumber isn't necessary

=MIN(IF(P3:P100,P3:P10))

Mike

"Mike H" wrote:

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

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

Array: Show only min values greater than "0"
 

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

"Arno" wrote:

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

Array: Show only min values greater than "0"
 

Enter must be the last key held down.

Mike F
"Arno" wrote in message
...
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

Array: Show only min values greater than "0"
 

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

"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