Return highest price paid row by part by customer

[rs1aj]

My report pulls the last two prices paid by customer for each part they purchase. I need a program to look at each individual customer by part. If it appears twice(last two prices paid), find the highest price and return that entire line and remove the other line. If it only appears once(they only bought it one time), return that entire line.

Thanks for you help.

[JieJenn]

Is this what you are looking for?

Please Login or Register  to view this content.

[rs1aj]

Thanks for your help on this. It is very close but it appears this vba is taking the largest price paid, regardless of part number, by each customer and deleting all other lines. I need it to look at each part number separately, by customer and return the highest price paid line.


Basically, in terms of writing it out, it would say something like this. For each customer, every change in part number, return the highest paid price line and delete the other.....if there is only one line by unique part number, just return that line.

I hope I said all this in a way you understand.

[MarvinP]

Hi rs1aj,

See if a Pivot Table helps answer this question. Play with Pivots a bit and see what they can do for you. No VBA or Formulas are needed for Pivots. You simply pull field names around and then right click in dropdowns and or values.

[rs1aj]

This will do the trick via pivot table. Thank you sir!