Lookup last date for class with specific criteria

[ATLGator]

Hi, I need some help but here's some quick background:

I manage a list of web-based classes offered by my company - each class name, date, time, and attendance is recorded in the list. Periodically, we send out marketing emails for these classes to promote attendance, which is also recorded in the list.

Issue:
I have a summary list of the class names (where each class is only listed once) and I'm trying to come up with a formula that will pull the class date for the last time that course was marketed.

I have attached an example of what I am trying to do - using colors instead of class names. The last date marketed for each color is already hard-keyed into the summary to show what should be there.

Any suggestions on how I can achieve this?

[martindwilson]

try in I5
=MAX(INDEX(($B$2:$B$33=H5)*($C$2:$C$33)*($A$2:$A$33="x"),0))

[alansidman]

In I5 type {=MAX(IF($B$2:$B$33=H5,$C$2:$C$33))} and be sure to use Control Shift Enter to ensure that has the curly brackets around it. You cannot type the curly brackets.

[ATLGator]

Genius! A MAX formula never even entered my brain. Thanks Alan!

[ATLGator]

Martin - you are equally a genius! Sorry about missing your post - I scrolled right to the bottom and didn't realize more than one person posted an answer.