Bilf,
Both also work, i forgotten to press key in combo.
can i know what does it function by "key combo of CTRL,SHIFT,ENTER"
beside that, if the product go by thousand of items.. is it i have to press
the combo everytime ?
"Biff" wrote:
OR -
Also entered as an array:
=VLOOKUP(MAX(IF(A2:A5="A1",B2:B5)),B2:C5,2,0)
Biff
"Biff" wrote in message
...
Hi!
Try this:
Entered as an array using the key combo of CTRL,SHIFT,ENTER:
=INDEX(C2:C5,MATCH(1,(A2:A5="A1")*(B2:B5=MAX(IF(A2 :A5="A1",B2:B5))),0))
Biff
"Lawrence" wrote in message
...
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..
|