Need to calculate median and mode similarly to how it could be done in a pivot table

Hello,

I need to find a way to calculate multiple medians and modes from a large data set. I've attached a screenshotScreen Shot 2014-12-04 at 11.58.53 AM.png. All of the values needed for calculation are in one column (D=Mass) but need to be spilt based on their category from another column.

In a separate column (B=Time), I have different time points at which each of my values were collected (sometimes I have hundreds of values for the same time point). Additionally, I'd like to go even further and separate that information by date (column A). Thus having a median and mode value for mass at each time point that is registerd per day.

I can easily find the average masses at each time point within each day using pivot tables, but I want to compare the median and mode values for my data as well. Is there any way to accomplish this, possibly using an array+macro or something else? My datasets are very large (>100,000 entries) and separating things out will be too time consuming.

Thanks,

Cheese

People using IE can't see posted pictures because the forum is broken -- but even if that were not true, please post workbooks, not pictures.

Row\Col	H	I	J
1	Band	Mass Med
2	BBGS	43.50	I2: {=MEDIAN(IF($E$2:$E$995=H2, $D$2:$D$995))}
3	YYYS	46.20
4	RRRS	47.40

You say that you want a comparison between the MEDIAN and MODE for your data. This workbook has the MEDIAN and MODE for the BAND / MASS with a count of each.