=SUMPRODUCT(MAX((A2:A6="Vanilla")*(B2:B6="A")*C2:C 6))

Just press ENTER


"jball" wrote:

Hi all,

Say I sell ice creams from different stores and want to know the most recent
date a sale was made from a specified store and flavour.

Flavour Store Date
Chocolate A 1/09/2009
Chocolate B 1/09/2009
Vanilla A 1/09/2009
Vanilla A 2/09/2009

Eg, If Flavour = Vanilla, If Store = A, what is the most recent date a sale
was made.
I wish this to be a formula. Any suggestions?
Thanks.