Adding "Max" to Formula to Get the Highest Number when solution is more than one Number

Still using Excel 2007??

can you explain in words what the "complex formula" is doing??

OK. I understand the formula now (and have simplified it). But I need to know the PRODUCT you're using.

No reply. So, this will work for O365 and not earlier products.

Formula:

Please Login or Register  to view this content.

Max, I have Office 365 so that is not a problem. However, when I download you file I get the number "160179", but what I want is just the number "179". I downloaded the sample file and it shows the 6 digit number rather than a three digiti number. Am I missing something?

Sorry I didn't get back to you sooner, but I was not home all day.

I have updated my profile to reflect I have Office 365.

Thanks for your help.

Work for Ex2016 or older:
Although I can't predict what your formidable formula will produce, I guess as follows:
For the rows where column I >= 12 and column J <= 20, take the maximum value from columns C, D, E, and this value must be greater than 150.
If that's correct, then I hope the formula below yields the correct result:
L2:

Please Login or Register  to view this content.

Drag down

That's what happens when you rely on a non-working formula to tell us what you want!

Try this. no copy paste. the formula (L2) spills down the column