Max value based on multiple variables

[Kaziglu Bey]

Basically what I have is something like this:

A	B	C
x	50	1
x	100	1
x	75	1
z	50	1
z	100	1
z	150	2
z	25	2

Column A = Various part numbers
Column B = Quantities per each
Column C = Size of the container being used






What I am looking to do is this:

A	B	C	D
x	50	1	100
x	100	1	100
x	75	1	100
z	50	1	100
z	100	1	100
z	150	2	150
z	25	2	150

Column A = Various part numbers
Column B = Quantities per each
Column C = Size of the container being used
Column D = The max quantity per part number per each unique container size.


Will a formula complete this task or do I need to go the route of a macro?