Hi Experts
Please refer the attached document and tell me how can I get the min
and max values of each month from the given data using sumproduct or
any other methode suitable to that.
Regards
Rajesh
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:O
Hi, Try Below
for Min
=MIN(IF((F1=$B$7:$B$297)*($C$7:$C$297),$C$7:$C$297)) with CSE
for Max
=MIN(IF((F1=$B$7:$B$297)*($C$7:$C$297),$C$7:$C$297)) with CSE
With warm regards,
Rajan Sharma
On Wed, Oct 30, 2013 at 5:08 PM, Rajesh thrissur wrote:
> Hi Experts
>
> Please refer the attached docu