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

's Computer Specifications

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

's Computer Specifications

Hi,

=MIN(IF(ISNUMBER(P3:P10)*P3:P10>0,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

's Computer Specifications

Hi,

The check for isnumber isn't necessary

=MIN(IF(P3:P10>0,P3:P10))

Mike

"Mike H" wrote:

> Hi,
>
> =MIN(IF(ISNUMBER(P3:P10)*P3:P10>0,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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

Enter must be the last key held down.

Mike F
"Arno" <(E-Mail Removed)> wrote in message
news:BD482CD7-A808-45BD-B1F5-(E-Mail Removed)...
> 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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...	Maria J-son	Microsoft Excel Programming	2	5th Mar 2006 12:20 PM
Lookup "greater than or equal to" in lookup array	=?Utf-8?B?aWNlbW91c2U=?=	Microsoft Excel New Users	3	16th Feb 2006 10:07 PM
are default values possible for "Application.Dialogs(xlDialogSortSpecial).show "?	broro183	Microsoft Excel Programming	4	17th Jan 2006 10:46 AM
Compare value to array of values, "best fit" (closest without going over, e.g. price is right)	KR	Microsoft Excel Programming	3	11th Jan 2005 06:51 PM
Can I create customized values for "show time as" such as "workin.	=?Utf-8?B?bXNjaGVsbGVy?=	Microsoft Outlook Calendar	1	7th Jan 2005 10:06 PM