Hi Lawrence
Forget that. It's nonsense.
It works for your sample set of data, but won't work of course if the
latest date isn't on a line with A1.
Regards
Roger Govier
Roger Govier wrote:
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..
|