So i've been struggling with this. Is there a way to calculate the median of a set of values based on Name and volume? An example of the data layout is below, what i want is to calculate the median value for a large table with multiple entries using formula or VBA.
<tbody>
Name
Volume
Value...