Cust# Product# Date Sold Price
5672 100WX202 05/01/13 $155.20
234123 550MP200X20 06/16/12 $12.60
2356 663405T12 01/04/13 $45.60
51190 100WX202 07/11/13 $124.70
5672 100WX202 03/01/14 $142.10
234123 550MP200X20 06/16/14 $12.60
I need a new spreadsheet showing what the last price each customer paid for each product they purchased from us. Here is what I would need from the above example:Cust# Product# Date Sold Price
5672 100WX202 03/01/14 $142.10
234123 550MP200X20 06/16/14 $12.60
51190 100WX202 07/11/13 $124.70
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
for last date
=MAX(($A$2:$A$7=H2)*($B$2:
for price
=INDEX($D$2:$D$7,MATCH(H2&
For 500klines, it's going to get slow though, maybe going through MS Query or a form of database might be a faster bet.
ee-match.xlsx