Hi kenil,
Pls change accordg to your data.
=MAX(IF(B1:B70,B1:B7))
=MIN(IF(A1:A70,A1:A7))
On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com 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
Dear Kenil,
Without using ctrl+shfit+enter
You can also use..
=SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2)))
On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA vijayajith...@gmail.comwrote:
On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA
...@gmail.com
Subject: Re: $$Excel-Macros$$ query for 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:$G20)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2
with a comment in another cell again,
Thanks and Regards.
--- On *Tue, 8/14/12, NOORAIN ANSARI noorain.ans...@gmail.com* wrote:
From: NOORAIN ANSARI noorain.ans...@gmail.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday
Yes Sir,
Perfect
Thanks a Ton.
Thanks Regards,
--- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote:
From: dguillett1 dguille...@gmail.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 5:05
and minimum values
Yes Sir,
Perfect
Thanks a Ton.
Thanks Regards,
--- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote:
From: dguillett1 dguille...@gmail.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum
values