Find a date with multiple criteria without using an array formula

Hi everybody, great mind-gathering factory here !!!.

Avoiding array formulas 'cause they're slow, found a fantastic solution by Ron Coderre at:

http://www.excelforum.com/excel-gene...y-formula.html

The formula was: =MIN(INDEX(((A2:A20<>F1)+(B2:B20<>G1))*10^99+C2:C20,0))

I'd like something like that, but with a MAX, not a MIN.

A date must be returned (the max-last-newest in a column, fulfilling criteria),
as the above example, but with a MAX, not a MIN.

Thank you.

Can you upload a small workbook which you are working with?

Can you give an example of criterias and designed result?

How about:

Please Login or Register  to view this content.