Find newest price

  • Thread starter Thread starter Jan Kronsell
  • Start date Start date
J

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
 
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
 
Try this:
=SUMPRODUCT((A2:A9=D1)*((B2:B9)=MAX((A2:A9=$D$1)*(B2:B9)))*(C2:C9))

Does that help?
 
Back
Top