Hi Lawrence

Yet another variation for a solution. The non array formula
=SUMPRODUCT(--(A2:A5="A1"),--(B2:B5=MAX(B2:B5)),C2:C5)

Regards

Roger Govier



Lawrence wrote:

currently, my boss asked me to look for latest price in a large volumn of
data in excel.

the data is like this...

Product transaction date selling price
A1 5/6/2005 $10
A2 6/6/2005 $11
A1 7/6/2005 $12
A1 8/6/2005 $10.5

Is there any formulas allow to get the A1 latest selling price?

thanks a lot..