Complex formula help

[Sunshine8790]

What formula do I use in this scenario:

I want the formula to return the Text from Column A.
I want it to return that text based on whatever the max value is in Column I.
I need that max value in Column I to be based on criteria from Columns D and E.

Example:

Name 1			Monday	Red				7
Name 2			Tuesday	Red				0
Name 3			Monday	Red				3
Name 4			Tuesday	Blue				1

So in the example above, I would need the formula to return "Name 1" based on the fact it's the highest value in Column I with the criteria of Monday and Red from Columns D and E.

And then I would need the formula in a different cell to return "Name 4" based on the fact it's the highest (and only) value in Column I with the criteria of Tuesday and Blue from D and E.

I hope that makes sense. Help appreciated.

 

[Fluff]

How about

=TAKE(SORT(FILTER(A2:I100,(D2:D100="Monday")*(E2:E100="red")),9,-1),1,1)

 

[Sunshine8790]

How about

=TAKE(SORT(FILTER(A2:I100,(D2:D100="Monday")*(E2:E100="red")),9,-1),1,1)

Perfect! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.