Find newest price

[Jan Kronsell]

I have a spreadsheet with three column, like

Part.no Date Price
1 02/02/05 10
2 02/02/05 15
3 03/11/05 30
4 04/11/05 40
1 05/05/05 12
3 05/10/05 25
4 06/06/05 50
1 06/09/05 20

How do I find the newest price for each part.no?

I tried with =SUMPRODUCT((A1:A50=D1)*(B1:B50=MAX(B1:B50))*(C1:C50)) but it
only works for the part-no that has been changed on the last date. D1 is
where i type the part.no which prize I need to find.

Jan

 

[CLR]

First, save your data and use this only on a copy...........

Data > Sort > choose Part.no and Ascending as the first Key, with Date and
Decending as the second Key...........the most recent date will be at the
top of each section of Part.nos...........

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Try this:
=SUMPRODUCT((A2:A9=D1)*((B2:B9)=MAX((A2:A9=$D$1)*(B2:B9)))*(C2:C9))

Does that help?

 

[Jan Kronsell]

I'll try it when I get home.

Jan