Re: Find Min of a row, but only greater than zero?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Bob,

> =MIN(IF(A2:M2<>),A2:M2)

I can't get that formula to work for me but

=MIN(IF(A2:M2<>0,A2:M2))

array entered does. Is it my 97 version of XL?

--
Regards

Sandy
sandymann@xxxxxxxxxxxxxx
Replace@mailinator with @tiscali.co.uk

"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:ez8xbEroFHA.3408@xxxxxxxxxxxxxxxxxxxxxxx
> =MIN(IF(A2:M2<>),A2:M2)
>
> which is an array formula, so commit with Ctrl-Shift-Enter
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "RocketDude" <mb1304-nospamatall@xxxxxxxxx> wrote in message
> news:OjEf8$qoFHA.3568@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi,
>>
>> Does anyone know how to find the minimum of a row of numbers, but only
>> for
>> numbers greater than zero? I have over three hundred rows I need to
> perform
>> this same function on, so naming the row is out of the question.
>>
>> For example, if my row is:
>>
>> 0 0 0 1 2 3 5 0 0.5
>>
>> I want to find "0.5".
>>
>> TIA
>>
>> --
>> Matthew
>>
>>
>
>


.

Relevant Pages

  • Re: Question for Dave Lipman
    ... Regards ... > Hi Sandy: ... abuse messages are *always* sent to the ISP indicating ... If the post is auto-generated by an infector such as Swen, ...
    (microsoft.public.security.virus)
  • Re: Excell, why oh why cant you just move rows up and down !!!!!
    ... Thanks for the catch Sandy. ... Regards ... >> to where it needs to go to, then letting go and choosing the 'Move here' ... >>> work around in Excell than to create a blank row to be over written by ...
    (microsoft.public.excel.misc)
  • Re: EXCELL Protection
    ... Regards ... > Sandy Mann wrote: ... >> that this post is entered in Google as ... >> Does anyone know if this is a fault in Goolge's new interface, ...
    (microsoft.public.excel.misc)
  • Re: Need help making a forumula!!!!
    ... Sandy ... >> I think you need a VBA macro with a loop. ... >>> First option ...
    (microsoft.public.excel.misc)
  • Re: counting dates
    ... Regards ... > "Sandy Mann" schrieb im Newsbeitrag ... >> any cell contains text. ... >>> Frank Kabel ...
    (microsoft.public.excel.newusers)