how to calculate median in vba excel scripting dictionary

Hi folks,

I have the below vba code which is calculating the sum of quantity against the items on click of the button from the "data" sheet and populate the results onto the "output" sheet. I need to calculate the median price also but struggling to do so. Can someone help on this please? I am attaching the sample data with code for your easy reference. Thanks in advance...

Please Login or Register  to view this content.

Thanks,
Abhi

Try

Please Login or Register  to view this content.

Thanks sintek, this works

Thanks jindon, this works