With E2 housing a product of interest:
1. If the transaction dates per product is an ascending series...
=LOOKUP(2,1/($A$2:$A$5=E2),$C$2:$C$5)
2.
=INDEX($C$2:$C$5,MATCH(MAX(IF($A$2:$A$5=E2,$B$2:$B $5)),$B$2:$B$5,0))
which needs to be confirmed with control+shift+enter.
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..
|