minimum values
Yes Sir,
Perfect
Thanks a Ton.
Thanks & Regards,
--- On Tue, 8/14/12, dguillett1 wrote:
From: dguillett1
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum
values
To: excel-macros@googlegroups.com
Yes Sir,
Perfect
Thanks a Ton.
Thanks & Regards,
--- On Tue, 8/14/12, dguillett1 wrote:
From: dguillett1
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 5:05 PM
Should do it
Don Guil
n another cell again,
>
> Thanks and Regards.
>
> --- On *Tue, 8/14/12, NOORAIN ANSARI * wrote:
>
>
> From: NOORAIN ANSARI
> Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
> To: excel-macros@googlegroups.com
> Date: Tuesday, August 14, 2012,
finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 12:27 PM
Dear Kenil,
Without using ctrl+shfit+enter
You can also use..
=SUMPRODUCT(MIN(($D2:$G2>0)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G2>0)*($D2:$G2)))
On Tue, Aug 14, 2012 at 5:38 PM, vija
Dear Kenil,
Without using ctrl+shfit+enter
You can also use..
=SUMPRODUCT(MIN(($D2:$G2>0)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G2>0)*($D2:$G2)))
On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA wrote:
>
>
> On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA wrote:
>
>>
>> Hi kenil,
>>
>> Pls change ac
Hi kenil,
Pls change accordg to your data.
=MAX(IF(B1:B7>0,B1:B7))
=MIN(IF(A1:A7>0,A1:A7))
On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala wrote:
> hi all,
>
> i have a query for finding maximum and minimum values.
> i have written my query in the excel sheet attached. pls help me solve my
> query
