Return maximum value, provided two conditions are met.

Hi All,

I have come undone in trying to solve this one, I need to return the maxium value of DDH1234, DDH1235 (etc..) from column C, provided that column D = "NO". See the attached image, may make it a little clearer.

Thanks in advance.

Chan

Excel.png