Required Excel Array formula to find the max and min values in a month and year

[madee0008]

Dear friends,

I am having an excel sheet(attached) to maintain the document status, in which i have to write a excel array formula to monitor the below status for every month basis,

1. Min Response time.
2. Max Response time.
3. Number of Max occurrence.
4. Response Percentage for june2014.

And conditions and logic is given in the excel sheet please refer,

Kindly help me friends,

Thank you,

[Bernie Deitrick]

Use a pivot table, and use date as the row field, grouped by month.

Or use array formulas like, this, where the dates are in A and the values are in B, entered using Ctrl-Shift-Enter.

=MAX(IF(YEAR(A:A)=2015,IF(MONTH(A:A)=1,B:B)))

Then counting you could use the result of the above in
=SUM(IF(YEAR(A:A)=2015,IF(MONTH(A:A)=1,IF(B:B=ABOVE,1))))