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

madee0008

New member
Joined
Mar 23, 2015
Messages
1
Reaction score
0
Points
0
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,
 

Attachments

  • Excel-25.03.15.xlsx
    16.7 KB · Views: 7
Back
Top