Min, Median & Maximum for multiple criteria

Hi,

I want the Min, Median & Maximum for multiple criterias. Column A & B has data and I want results in column E (Min), F (Med) & G (Max) based on the value in cell D.

Thanks

Min and Max are achieved easily with Pivot Table. No good ideas on the Median yet, though.

You can calculate median in original table first then add it in PT

I want this to be dynamic and not in PT and results in column E (Min), F (Med) & G (Max) when the value changes in cell D.